Workflow and ServiceDesk Community

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