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.
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.
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
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
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.
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.