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

Comments

Please log in to comment

Answers

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
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
Answered 09/21/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
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
Answered 09/21/2011 by: rgiroux
Senior Yellow Belt

Please log in to comment
0
Yes you can do something similar with labels. In your kbox there is an example ldap label called "MemberOfBuildingA"that should help
Answered 09/21/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
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
Answered 09/21/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
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
Answered 09/22/2011 by: rgiroux
Senior Yellow Belt

Please log in to comment
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.
Answered 10/05/2011 by: dchristian
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity