cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

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

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

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!