With the new "Software Request Process" in ServiceDesk 8.1 there have been some new Reports added to the SMP.
Table Of Contents
These can be found in the SMP.
Reports | Service and Asset Management | ServiceDesk
There are also a number of Hidden Reports.
---
Available Software
This shows what Software can be chosen for a Machine in the Request.
In the Model: List Available Software there is a new Component
This looks for a Repot with the following Guid: 7DF44266-9612-4B92-A52C-108161866642
If you open any Report in a new Window you can see the URL used to view said Report.
Run this through a decoder to make this more readable, and add the GUID on the end:
Reports | Service and Asset Management | ServiceDesk | Available Software
This is a Hidden and uneditable Report, you could clone this to see, modify or just View as XML to see the SQL used.
SQL
DECLARE @raIdProductContainsComponent uniqueidentifier DECLARE @raIdSoftwareProducttoCompany uniqueidentifier SET @raIdProductContainsComponent = '9d67b0c6-beff-4fcd-86c1-4a40028fe483' SET @raIdSoftwareProducttoCompany = 'd5c66d5a-7686-4ca2-b7c1-ac980576ce1d' SELECT DISTINCT dprd.[Guid] as ProductGuid, dprd.Name as ProductName, ver.[Version] as ProductVersion, company.[Name] as Manufacturer FROM [vAC_DeliverableSoftwareProducts] dprd INNER JOIN [ResourceAssociation] as raProductContainsComponent INNER JOIN [RM_ResourceSoftware_Release] as rel on raProductContainsComponent.ResourceAssociationTypeGuid = @raIdProductContainsComponent and raProductContainsComponent.ChildResourceGuid = rel.[Guid] on dprd.[Guid] = raProductContainsComponent.ParentResourceGuid LEFT OUTER JOIN [ResourceAssociation] as raSoftwareProductToCompany INNER JOIN [vRM_Company_Item] as company on raSoftwareProductToCompany.ResourceAssociationTypeGuid = @raIdSoftwareProducttoCompany and raSoftwareProductToCompany.ChildResourceGuid = company.[Guid] on dprd.[Guid] = raSoftwareProductToCompany.ParentResourceGuid LEFT OUTER JOIN [Inv_Software_Product_Version] as ver on dprd.[Guid] = ver._ResourceGuid ORDER BY ProductName