ServiceDesk - Software Request Process - Hidden Reports

With the new "Software Request Process" in ServiceDesk 8.1 there have been some new Reports added to the SMP.

Table Of Contents

• Index
• Overview
• Config
• SMP
• Reports
• Hidden Reports (this)
• SQL
• WFs
• DLLs

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 DISTINCTdprd.[Guid] as ProductGuid, dprd.Name as ProductName,ver.[Version] as ProductVersion,company.[Name] as Manufacturer
FROM [vAC_DeliverableSoftwareProducts] dprdINNER JOIN [ResourceAssociation] as raProductContainsComponent	INNER JOIN [RM_ResourceSoftware_Release] as rel 		on raProductContainsComponent.ResourceAssociationTypeGuid = @raIdProductContainsComponent		and raProductContainsComponent.ChildResourceGuid = rel.[Guid]	on dprd.[Guid] = raProductContainsComponent.ParentResourceGuidLEFT 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.ParentResourceGuidLEFT OUTER JOIN [Inv_Software_Product_Version] as ver	on dprd.[Guid] = ver._ResourceGuid
ORDER BY ProductName