/build/static/layout/Breadcrumb_cap_w.png

How to make a report with all software installed on a computer?

Hi Guy's,
I know this question is lame but I didn't found a way to create this simple report using the assistant and I don't know sql to do that.
How can i do that?
Best regards,
Rildo

0 Comments   [ + ] Show comments

Answers (6)

Posted by: GillySpy 12 years ago
7th Degree Black Belt
0
Duplicate the canned report called "Software on computer". Then modify it for a specific machine:
e.g.

Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, DISPLAY_NAME,
DISPLAY_VERSION, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) where MACHINE.ID =
MACHINE_SOFTWARE_JT.MACHINE_ID and SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and not IS_PATCH
and MACHINE.NAME = 'enter machine name here'
order by MACHINE_NAME, DISPLAY_NAME
Posted by: rgiroux 12 years ago
Senior Yellow Belt
0
Many Thanks GillySpy.
Work very good.
Sorry for take your time but i still have a question:
I have a Computer Label and this label is connected to a LDAP Label.
It is possible to do the same for my Label Computer Group?
Best regards,
Rildo
Posted by: GillySpy 12 years ago
7th Degree Black Belt
0
Yes you can do something similar with labels. In your kbox there is an example ldap label called "MemberOfBuildingA"that should help
Posted by: GillySpy 12 years ago
7th Degree Black Belt
0
I just realized I had your question confused with another post. Regardless of where the label came from (ldap , smart, etc) you could incorporate a label. Don't have time to illustrate atm
Posted by: rgiroux 12 years ago
Senior Yellow Belt
0
Hi GillySpy,
Thanks for you explanation. At the moment I can create the report for a computer, thanks your help.
Now, I'm trying to do the same for a computer group.
I already have a Label and I need to change the cod you give to me for use this label.
Where I need to change?
Best regards,
Rildo
Posted by: dchristian 12 years ago
Red Belt
0
rgiroux,

Your going to want to join the label and machine label join tables to the report.

Give the sql a shot and post what you have.

If you post an attempt, well help with the rest.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

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