GopalRaghvani
Level 5

How do I create a report with Software titles with EoS dates and devices they are installed on?

Jump to solution

I want to create a report listing Software titles with EoS dates and devices it is installed on.

I got a query to report Software titles with EoS, but don't know how to include devices it is installed on.

   SELECT
    sto.Publisher, sto.SoftwareTitleName,
    st.SupportedUntil,
    st.ExtendedSupportUntil
FROM SoftwareTitleINfo sto
INNER JOIn SoftwareTitle st
ON St.SoftwareTitleID = sto.SoftwareTitleID
Where
 sto.HasInstalls > 0 
AND
(SupportedUntil <= '01/08/2050' Or
 ExtendedSupportUntil <= '01/08/2050')

1 Solution
jjensen
Flexera Alumni

Hello @GopalRaghvani,

You could use a JOIN to the InstalledSoftware table (contains SoftwareTitleIDs and ComplianceComputerIDs), then JOIN that to ComplianceComputer.

HTH,

Joseph

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!

View solution in original post

1 Reply
jjensen
Flexera Alumni

Hello @GopalRaghvani,

You could use a JOIN to the InstalledSoftware table (contains SoftwareTitleIDs and ComplianceComputerIDs), then JOIN that to ComplianceComputer.

HTH,

Joseph

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!

View solution in original post