Running a report on a collection

[Jovin]

Is there a way I can run a report on a collection that I created that list what softwares are installed on the PC on that collection. I'd like to gather information on a collection (department) what version of Lotus notes, Office version, 03' or 07', and version of Mozilla and IE.

 

Thanks,

[wmmayms]

Hi

 

Here you go.

Add this as SQL statement:

SELECT  Count(*) AS '#', A.DisplayName0, A.Version0

FROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM B, v_FullCollectionMembership C

WHERE A.ResourceID = B.ResourceID
AND A.ResourceID = C.ResourceID
AND A.DisplayName0 NOT LIKE 'Hotfix for %'
AND A.DisplayName0 NOT LIKE 'Korrigering för Windows %'
AND A.DisplayName0 NOT LIKE 'Security Update for %'
AND A.DisplayName0 NOT LIKE 'Säkerhetsuppdatering för Windows%'
AND A.DisplayName0 NOT LIKE 'Snabbkorrigering för Windows %'
AND A.DisplayName0 NOT LIKE 'Update for Microsoft %'
AND A.DisplayName0 NOT LIKE 'Update for Office %'
AND A.DisplayName0 NOT LIKE 'Update for Outlook %'
AND A.DisplayName0 NOT LIKE 'Update for Windows %'
AND A.DisplayName0 NOT LIKE 'Uppdatering för Windows XP%'
AND A.DisplayName0 NOT LIKE 'Windows 2000 Hotfix%'
AND A.DisplayName0 NOT LIKE 'Windows Server 2003 Hotfix%'
AND A.DisplayName0 NOT LIKE 'Windows XP Hotfix%'

AND CollectionID = @collection

GROUP BY A.DisplayName0, A.Version0
ORDER BY A.DisplayName0

 

 

Then create a prompt named "collection"

And add this as SQL prompt statement:

 

SELECT CollectionID, Name
FROM v_Collection

 

Cheers

[MRaybone]

Or you could go into the Reporting node and run the 'Software 01A - Summary of installed software in a specific collection' report. For 'Collection' just click the Values button and select the desired collection, change 'Specify the number of rows to return' to something like 1500 and hit Display.

 

If you get no results then right click the Asset Intelligence node, click 'Edit Asset Intelligence Reporting Classes' and tick at least SMS_InstalledSoftware and SMS_InstalledSoftwareMS. After your clients have run an inventory you should get some results.

 

MRaybone.