Try a query like the following:
SELECT ie.*
FROM dbo.ComplianceComputer cc
CROSS APPLY dbo.Grid_ComputerInstallerEvidenceListModelByComputer(cc.ComplianceComputerID, NULL) ie
WHERE cc.ComputerName = 'xxx37583'
Note that this query will work with current FlexNet Manager Suite releases, but uses a database function that may change without notice in future releases.
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
