Reports - software inventory / group by labels
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
I anyone has any mysql code that they could share that would be very helpful on this end.
Thanks
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
dchristian
12 years ago
Posted by:
RichB
12 years ago
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):
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

so that the conversation will remain readable.