(imported comment written by rdamours91)
You’ve really got to ask for a raise man.
The web QNA could not parse the code but it runs when I add the code in as a custom report. I’m getting an “expression could not be parsed” when I try to web QNA it…
Here’s a rought sampling sampling of the output…I’ll of course add headers, etc. as time permits.
380-HLE Centre For Education Quickbooks Basic Edition 2003
380-JGRISWOL Centre For Education QuickBooks
384-LGEBARA Centre For Education QuickBooks Basic Edition 2003,QuickBooks Pro Edition 2007,QuickBooks Pro Edition 2006,QuickBooks Transfer - 1.0.0
OFF225-001 Caernarvon 225 QuickBooks Basic Edition 2003
OFF055-SROFF-06 Victoria School of Performing And Visual Arts QuickBooks Basic Edition 2003
384-AASARIA Centre For Education QuickBooks Basic Edition 2003,QuickBooks Pro Edition 2007,QuickBooks Pro Edition 2006,QuickBooks Transfer - 1.0.0
OFF055-SROFF-09 Victoria School of Performing And Visual Arts QuickBooks Basic Edition 2003
347-MADAMS2 Centre For Education QuickBooks Basic Edition 2003,QuickBooks Pro Edition 2007,QuickBooks Transfer - 1.0.0
TCH106-STFROOM Beacon Heights 106 QuickBooks Basic Edition 2003
OFF253-06 Bannerman 253 QuickBooks Basic Edition 2003
OFFICE-05 Balwin 502 QuickBooks Basic Edition 2003
OFFICE-04 Balwin 502 QuickBooks Basic Edition 2003
OFF253-008 Bannerman 253 QuickBooks Basic Edition 2003
Here’s the code that ran…
I can now do variations of this report to get any specific installed app…thanks a ton…you’ve been a big time saver. I had the code partially written on my own but did not have time to finish.
<?relevance
trs of
(td of name of it &
td of concatenation "," of (values of result (it, bes property "School Name by IP Range")) &
td of concatenation "," of (values of result (it, bes property "Installed Applications - Windows")) whose (it as lowercase contains "quickbooks"))
of bes computers whose
(exists (value of result (it, bes property "Installed Applications - Windows")) whose (it as lowercase contains "quickbooks") AND
exists (value of result (it, bes property "School Name By IP Range")))
?>
The data is exactly what I’m looking for…i"ll just see if I can sort the first 2 columns in the web report somehow…or I’ll port the output out to csv and manipulate it that way for the time being.
You da man…I’m sure there are others that would be interested in a variation of this code.