I want report on my software inventory and want to group the report based off of the custom labels that i have created within the kbox 1000 that i have created.

I anyone has any mysql code that they could share that would be very helpful on this end.

Thanks
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2
ryan_j_boyle,

Here try this.

Add it as a new SQL report, and have it break on label name.
SELECT S.DISPLAY_NAME,
L.NAME AS LABEL_NAME
FROM SOFTWARE S,
SOFTWARE_LABEL_JT SL,
LABEL L
WHERE S.ID = SL.SOFTWARE_ID
AND L.ID = SL.LABEL_ID
ORDER BY NAME
Answered 11/03/2010 by: dchristian
Red Belt

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
Thanks for that SQL report dchristian. It lists all the software titles matching a smart software label.

If you want to see the computers matching a smart software label then this works for us as a template. Replace the long double-clickable word "TemplateLabelNameToReplaceGoesHere" with your actual smart software label name (Thanks to Gerald Gillespie for this):

select MACHINE.ID as MID, MACHINE.NAME, MACHINE.SYSTEM_DESCRIPTION,
MACHINE.IP, SOFTWARE.ID,
SUBSTRING(USER_LOGGED, LOCATE('\\\\',USER_LOGGED)+1) as SHORT_USER_LOGGED from MACHINE,
MACHINE_SOFTWARE_JT, SOFTWARE , SOFTWARE_LABEL_JT SWL, LABEL
where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
and SOFTWARE.ID=SWL.SOFTWARE_ID and LABEL.ID=SWL.LABEL_ID
and LABEL.NAME='TemplateLabelNameToReplaceGoesHere'
group by MACHINE.ID
order by MACHINE.NAME
Answered 11/04/2010 by: RichB
Third Degree Green Belt

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