Jump to content


Sign in to follow this  
Jovin

Running a report on a collection

Recommended Posts

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,

Share this post


Link to post
Share on other sites


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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...