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

[GopalRaghvani]

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

[jjensen · Accepted solution]

Hello @GopalRaghvani,

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

HTH,

Joseph