/bundles/itninjaweb/img/Breadcrumb_cap_w.png
Can I create a smart label using display version from software inventory and add it with computer inventory's software titles?
0 Comments   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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
Second Degree Green Belt

Please log in to comment