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
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)
Please log in to answer
Posted by:
GillySpy
13 years ago
Duplicate the canned report called "Software on computer". Then modify it for a specific machine:
e.g.
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
13 years ago
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
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
13 years ago
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
13 years ago
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
13 years ago
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
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
13 years ago
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.
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.