/build/static/layout/Breadcrumb_cap_w.png

Mixing Smart Labels

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

Answers (5)

Posted by: cblake 13 years ago
Red Belt
0
With a bit of SQL magic you can accomplish that, but not through the wizard.
Posted by: airwolf 13 years ago
Red Belt
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.
Posted by: sophie 13 years ago
Yellow Belt
0
Really it is a great forum I like very much because it is beneficial for us.
==========
plrprivatelabelrights.com
Posted by: dchristian 13 years ago
Red Belt
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}%') )))
Posted by: londeaux 13 years ago
Second Degree Green Belt
0
Thank you, thank you, thank you.

That script worked.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
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