/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

Community Chosen Answer


Answers

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.
Answer this question or Comment on this question for clarity

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

Please log in to comment