(imported topic written by sminisini91)
Hi,
I’ve been running a query to export a few properties for all our desktops in order to import those queries into our CMDB. The query has been running fine until recently but now the query times out (the number of clients has increased and I’m also querying for more properties, so that’s not really a surprise)
I was wondering if I can either increase the time out in the web reports or if I could somehow optimize the query. Here is the session relevance I’m using:
(item 0 of it & “$” & item 1 of it & “$” & item 2 of it & “$” & item 3 of it & “$” & item 4 of it & “$” & item 5 of it & “$” & item 6 of it & “$” & item 7 of it & “$” & item 8 of it & “$” & item 9 of it & “$” & item 10 of it & “$” & item 11 of it & “$” & item 12 of it & “$” & item 13 of it & “$” & item 14 of it & “$” & item 15 of it & “$” & item 16 of it) of ((if (exists result (item 0 of it, item 1 of it) ) then (concatenation “;” of values of result (item 0 of it, item 1 of it)) else ("")) , (if (exists result (item 0 of it, item 2 of it) ) then (concatenation “;” of values of result (item 0 of it, item 2 of it)) else ("")) , (if (exists result (item 0 of it, item 3 of it) ) then (concatenation “;” of values of result (item 0 of it, item 3 of it)) else ("")) , (if (exists result (item 0 of it, item 4 of it) ) then (concatenation “;” of values of result (item 0 of it, item 4 of it)) else ("")) , (if (exists result (item 0 of it, item 5 of it) ) then (concatenation “;” of values of result (item 0 of it, item 5 of it)) else ("")) , (if (exists result (item 0 of it, item 6 of it) ) then (concatenation “;” of values of result (item 0 of it, item 6 of it)) else ("")) , (if (exists result (item 0 of it, item 7 of it) ) then (concatenation “;” of values of result (item 0 of it, item 7 of it)) else ("")) , (if (exists result (item 0 of it, item 8 of it) ) then (concatenation “;” of values of result (item 0 of it, item 8 of it)) else ("")) , (if (exists result (item 0 of it, item 9 of it) ) then (concatenation “;” of values of result (item 0 of it, item 9 of it)) else ("")) , (if (exists result (item 0 of it, item 10 of it) ) then (concatenation “;” of values of result (item 0 of it, item 10 of it)) else ("")) , (if (exists result (item 0 of it, item 11 of it)) then (concatenation “;” of values of result (item 0 of it, item 11 of it)) else ("")), id of item 0 of it as string, (if (exists result (item 0 of it, item 12 of it) ) then (concatenation “$” of values of result (item 0 of it, item 12 of it)) else ("")),(if (exists result (item 0 of it, item 13 of it)) then (concatenation “;” of values of result (item 0 of it, item 13 of it)) else ("")),(if (exists result (item 0 of it, item 14 of it)) then (concatenation “;” of values of result (item 0 of it, item 14 of it)) else ("")), (if (exists result (item 0 of it, item 15 of it)) then (concatenation “;” of values of result (item 0 of it, item 15 of it)) else ("")), (if (exists result (item 0 of it, item 16 of it)) then (concatenation “;” of values of result (item 0 of it, item 16 of it)) else (""))) of (elements of intersection of ((sets of computers of results whose (value of it as lowercase contains “workstation”) of bes property “OS Type”)), bes property “Computer Name”, bes property “Computer Manufacturer”, bes property “Computer Model”, bes property “Serial Number - Windows Computers”, bes property “IP Address”, bes property “Last Logged In User”, bes property “Drive Sizes and Free Space”, bes property “RAM”, bes property “Full OS Name and Service Pack Level”, bes property “Maintenance Window”, bes property “Reboot Schedule”, bes property “Last Reboot Time”, bes property “OS Type”, bes property “Laptop - Windows”, bes property “Trend Micro OfficeScan Client Pattern Version”, bes property “DNS Name”)
Thanks