Can I create a smart label using display version from software inventory and add it with computer inventory's software titles?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
With a bit of SQL magic you can accomplish that, but not through the wizard.
Answered 01/21/2011 by: cblake
Red Belt

Please log in to comment
0
In a report, you can follow cblake's advice. If you are talking about displaying the versions alongside the software titles on the inventory page - that is not possible.
Answered 01/24/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Really it is a great forum I like very much because it is beneficial for us.
==========
plrprivatelabelrights.com
Answered 01/24/2011 by: sophie
Yellow Belt

Please log in to comment
0
Here is a template you can use to create a computer inventory label looking for a specific display name & version.

Its not as bad as it looks.

The only thing that needs to change is the last 2 lines.

SELECT *,
Unix_timestamp(NOW()) - Unix_timestamp(LAST_SYNC) AS LAST_SYNC_TIME,
Unix_timestamp(MACHINE.LAST_SYNC) AS LAST_SYNC_SECONDS
FROM ORG1.MACHINE
LEFT JOIN KBSYS.KUID_ORGANIZATION
ON KUID_ORGANIZATION.KUID = MACHINE.KUID
LEFT JOIN KBSYS.SMMP_CONNECTION
ON SMMP_CONNECTION.KUID = MACHINE.KUID
AND KUID_ORGANIZATION.ORGANIZATION_ID = 1
WHERE ((( 1 IN (SELECT 1
FROM ORG1.SOFTWARE,
ORG1.MACHINE_SOFTWARE_JT
WHERE MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
AND MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
AND SOFTWARE.DISPLAY_NAME LIKE '%{ENTER SOFTWARE HERE}%'
AND SOFTWARE.DISPLAY_VERSION LIKE '%{ENTER VERSION HERE}%') )))
Answered 01/26/2011 by: dchristian
Red Belt

Please log in to comment
0
Thank you, thank you, thank you.

That script worked.
Answered 01/27/2011 by: londeaux
Green Belt

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