Discovery and Inventory Group

 View Only

Computers With Software Installed Report 

May 13, 2014 03:13 PM

I have needed an exportable version of the Computers with Software Installed view below several times. Unfortunatley, it is not available as a default report in the console or as a view in the database. Since I'm working through Microsoft True Up this week, I decided to build a report version to help with our licensing.

ComputersWithSoftwareInstalled.jpg

After doing some digging and getting some help from support, I found the spAC_GetComputersBySoftwareProduct stored procedure. From there, I was able to build out a report that allows you to select from a dropdown of all of your metered software products and to then see all of the data contained in screenshot above for the selected Software product.

I've attached two reports to this post. You will need to import both reports in order for this to work.

  1. Computers With Software Installed.xml generates the drop down of all metered software products.
  2. Installed and Metered Software Items.xml is the main report.

Statistics
0 Favorited
8 Views
2 Files
0 Shares
0 Downloads
Attachment(s)
xml file
Computers With Software Installed.xml   12 KB   1 version
Uploaded - Feb 25, 2020
xml file
Installed and Metered Software Items.xml   9 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

Mar 21, 2018 04:45 PM

Please correct the above code:

 

Declare @ProductUsage Table(

ResourceGuid uniqueidentifier

,Name varChar(36)

,[OS Name] varChar(36)

,UsedCount int

,DeliveryStatus varChar(36)

,SoftwareComponentGuid varChar(36)

,[Software Name] nvarchar(128)

,LastStart DateTime

,InstallDate DateTime

)

INSERT @ProductUsage

EXECUTE spAC_GetComputersBySoftwareProduct

@ComputerName=N'%%'

, @SelectTop=1

, @Trustee=N'{2E1F478A-4986-4223-9D1E-B5920A63AB41},{402DC8EC-CC6C-4D4B-B389-F12AE18CB02F},{582029E2-FC5B-4717-8808-B80D6EF0FD67},{9791A53A-6F81-4701-B878-E68C4C540057},{A8508E1D-C6A5-4F9B-A1F4-3D401C44564D},{AE41E526-1963-4C40-A456-A67E845F4D19},{B760E9A9-E4DB-404C-A93F-AEA51754AA4F}'

, @SoftwareComponentGuids= '%DesiredComponentGuid%' -- change by the desired software guid

Select

PU.Name

,PU.[OS Name]

,PU.[Software Name]

,PU.UsedCount

,PU.LastStart

,SwINV.Usage

,SWInv.[Usage Previous Month]

,PU.InstallDate

from @ProductUsage PU

JOIN ( Select Inv._ComputerResourceGuid

,inv.Usage

,inv.[Usage Previous Month]

,itm.Name

from

dbo.Inv_SoftwareProduct_InstallationInfo INV

JOIN dbo.vItem itm ON itm.Guid=inv._ResourceGuid

where itm.Guid = '%DesiredComponentGuid%' -- change by the desired software guid

and itm.ClassGuid = 'AA34B7C1-1C65-4085-A9D1-E7F83D633B2F'

Group By Inv._ComputerResourceGuid ,inv.Usage, inv.[Usage Previous Month],itm.Name) as SwINV ON PU.ResourceGuid = SWINv._ComputerResourceGuid

Apr 28, 2016 05:54 AM

Hi All,

I would like to have "Computers With Software Installed" report for all metered software without dropdown. It would be nice if you could provide the sql query where we can see all the software usage detail in a single page.

Your help would be much appreciated.

 

Regards,

Sam

 

 

 

 

Oct 14, 2015 12:03 PM

Are you getting errors on importing "Computers with Software Installed" report? If so I had to change the Parent Folder GUID in the xml file since I didn't have whatever folder it was exported from on my system.

Oct 23, 2014 02:15 PM

Hello,  do you need to have any specific part of Client management Suite installed for this to work.  I'm trying with just the Symantec Client Suite 7.5 installed but get errors.  Just wondering if the Asset management suite would need to be installed.  Thanks.

Related Entries and Links

No Related Resource entered.