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:
SELECT M.NAME, M.IP, M.LAST_SYNC, ASSET_LOCATION.NAME, SOFTWARE.DISPLAY_NAME
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%"
Answers (3)
Can I ask you to clarify what you are aiming to get from this report, what is the purpose?
Comments:
-
They want to know which servers have which version of a particular software installed, in addition to which servers don't have the software installed. - lama01 3 years ago
The easiest way is to run Servers without the software as a separate report as you can then craft your WHERE statement to "is not like" or whatever fits the requirements
I added DISPLAY_VERSION to the top line and now I get the version #. Any idea how to included in this same report, servers without the software installed?