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)
Please log in to answer
Posted by:
cblake
13 years ago
With a bit of SQL magic you can accomplish that, but not through the wizard.
Posted by:
airwolf
13 years ago
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
Really it is a great forum I like very much because it is beneficial for us.
==========
plrprivatelabelrights.com
==========
plrprivatelabelrights.com
Posted by:
dchristian
13 years ago
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.
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}%') )))
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.