/build/static/layout/Breadcrumb_cap_w.png

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%"


0 Comments   [ + ] Show comments

Answers (3)

Posted by: Hobbsy 4 months ago
Red Belt
1

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 4 months ago
Posted by: Hobbsy 4 months ago
Red Belt
1

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

 

Posted by: lama01 4 months ago
Green Belt
0

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?

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ