Software Report w/ Version
Can anyone help complete this SQL Query? Im looking to get a report on a single software showing Name, IP, Last Sync, Site location, Software Display Name and version. (I am missing version) But I would also like to have in the same report servers missing the software. (I assume just have blank fields in name and version?) This is what I have so far. Its just missing the version and servers without the software:
FROM MACHINE M
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.MACHINE_ID = M.ID
LEFT JOIN SOFTWARE on SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
Inner JOIN ASSET on ASSET.MAPPED_ID = M.ID
LEFT JOIN ASSET ASSET_LOCATION ON ASSET_LOCATION.ID = ASSET.LOCATION_ID
Where SOFTWARE.DISPLAY_NAME like "snow%"