Sean, I don't see any version info for you, but on 7.0.3 (patch 9) at least, that main table on the Asset Management console refreshes something like three different times when you open it from the home page. Combined with the slow queries you see, it can be agonizing to use. The code was sufficiently spaghettified that I didn't take the time to fix it, but depending on your idea of "fun", you could. :-)
One thing that sort of helps is to set the default class that gets searched when the console first loads. With the console open, select "Application Preferences" on the left. On the asset management tab, under the "Search Criteria Default" section, choose a CI Type that isn't used very much in your organization (mine is currenlty set to "Role"). I suppose you could change it for all users, but I haven't done that yet. Not ideal, but something. Thad On Mon, Jul 18, 2011 at 5:49 AM, Garrison, Sean (Norcross) < [email protected]> wrote: > ** > > Sort order on the table, on AST:BaseElement, and on > BMC.CORE:BMC_BaseElement are all blank. I tried adding “InstanceId” to the > sort order which would return the results fast. However it added both > request id and instance id to the “ORDER BY” portion of the SQL. This is > out of the box workflow with the asset management console so you should (in > theory) see the same thing. Weird stuff ….**** > > ** ** > > Sean**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Meyer, Jennifer L > *Sent:* Friday, July 15, 2011 5:30 PM > *To:* [email protected] > *Subject:* Re: Asset Management Console is slow ... trying to index/tweak > query with no luck**** > > ** ** > > ** **** > > Did you check the sort order set on the table?**** > > ** ** > > Jennifer Meyer**** > > Remedy Technical Support Specialist**** > > State of North Carolina**** > > Office of Information Technology Services **** > > Service Delivery Division ITSM & ITAM Services**** > > Office: 919-754-6543**** > > ITS Service Desk: 919-754-6000**** > > [email protected]**** > > http://its.state.nc.us**** > > ** ** > > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and may be disclosed to third parties only by an > authorized State Official.**** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Garrison, Sean (Norcross) > *Sent:* Friday, July 15, 2011 4:06 PM > *To:* [email protected] > *Subject:* Asset Management Console is slow ... trying to index/tweak > query with no luck**** > > ** ** > > ** **** > > Hello ARSListers,**** > > ** ** > > I was wondering if you guys had done any tweaking on the asset management > console and what suggestions you could make. I have the following query:* > *** > > ** ** > > SELECT * FROM ( SELECT > T1262.C1,C210000000,C7,C200000005,C179,C200000007,C240001008,C240001003,C200000001,C260100004,C490021100,C200000020,C200000003,C200000004,C240001002,C260000001,C400129200,C240001005,C1000000150,C8,C400079600 > FROM T1262 WHERE ((T1262.C400127400 = 'BMC.ASSET') AND (1 = 1) AND (T1262.C7 > >= 3) AND (T1262.C7 <= 3) AND (1 = 1) AND (1 = 1)) ORDER BY 1 ASC ) WHERE > ROWNUM <= 51**** > > ** ** > > Which is generated from the out of the box asset management console when it > first loads. It is taking ~51 seconds for this query to run. If I change > it to this:**** > > ** ** > > SELECT * FROM ( SELECT > T1262.C1,C210000000,C7,C200000005,C179,C200000007,C240001008,C240001003,C200000001,C260100004,C490021100,C200000020,C200000003,C200000004,C240001002,C260000001,C400129200,C240001005,C1000000150,C8,C400079600 > FROM T1262 WHERE ((T1262.C400127400 = 'BMC.ASSET') AND (1 = 1) AND (T1262.C7 > >= 3) AND (T1262.C7 <= 3) AND (1 = 1) AND (1 = 1)) ) WHERE ROWNUM <= 51** > ** > > ** ** > > The query takes ~ 7 seconds to run. I have double checked all of the “Sort > Order” settings for BMC.CORE:BMC_BaseElement, table, and AST:BaseElement to > no avail. I can’t seem to get Remedy to remove the “ORDER BY 1 ASC” part. > **** > > ** ** > > On a side note I have found that this form is also using the > “AST:BaseElement”. I tried changing it to “BMC.CORE:BMC_BaseElement” so > that it does not use the join. That doesn’t do much either. **** > > ** ** > > I have also tried creating an index on base element to include the > following fields when searching BMC.CORE:BMC_BaseElement:**** > > ** ** > > Request ID, InstanceId, DatasetID, and Status**** > > ** ** > > That didn’t seem to speed it up either. Any help/suggestions?**** > > ** ** > > Thanks,**** > > ** ** > > Sean**** > > ** ** > > ** ** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
