Lab software report
Ok so I've been trying to wrap my head around a request I'm fielding for a report of all software being utilized in roughly 5 computers labs spread throughout our network.
I need to know if it's possible to either jury rig an existing report or have a new one created that would do the following:
Scan through all network devices, disregarding those that don't have a last user login that contains the string "lab".
Once all non-lab devices are pruned out, group devices by lab number and list all common software present on those machines, preferably with a count of total instances of that software in that lab for each program.
Also it should be noted that in each lab we have a communal user account "Lab (building number)" that users log in with. For example, in lab 8 all the computers should have a last user login of Lab 08.
It seems like its something that should be possible but its way beyond me so any help would be greatly appreciated. Even if someone could help with just finding a way to prune out all non-lab computers from the list it would be an amazing help.
Thanks,
Cam
I need to know if it's possible to either jury rig an existing report or have a new one created that would do the following:
Scan through all network devices, disregarding those that don't have a last user login that contains the string "lab".
Once all non-lab devices are pruned out, group devices by lab number and list all common software present on those machines, preferably with a count of total instances of that software in that lab for each program.
Also it should be noted that in each lab we have a communal user account "Lab (building number)" that users log in with. For example, in lab 8 all the computers should have a last user login of Lab 08.
It seems like its something that should be possible but its way beyond me so any help would be greatly appreciated. Even if someone could help with just finding a way to prune out all non-lab computers from the list it would be an amazing help.
Thanks,
Cam
0 Comments
[ + ] Show comments
Answers (5)
Please log in to answer
Posted by:
dchristian
12 years ago
Hey camrevard,
I just did that for someone else.
[link]http://itninja.com/question/finishing-image-and-running-sysprep94[/link]
Let me know if it works for you.
I just did that for someone else.
[link]http://itninja.com/question/finishing-image-and-running-sysprep94[/link]
Let me know if it works for you.
Posted by:
dchristian
12 years ago
Here's a detailed version by Name, version and vendor.
Or just by software name:
Remember to change the label from 'workstations'
SELECT
DISPLAY_NAME,
DISPLAY_VERSION,
PUBLISHER,
COUNT(*) AS INSTALLED
FROM
(
SOFTWARE,
MACHINE_SOFTWARE_JT,
MACHINE,
MACHINE_LABEL_JT ML,
LABEL L
)
WHERE
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
AND MACHINE.ID = ML.MACHINE_ID
AND ML.LABEL_ID = L.ID
AND NOT IS_PATCH
AND L.`NAME` = 'WORKSTATIONS'
GROUP BY
DISPLAY_NAME,
DISPLAY_VERSION,
PUBLISHER
ORDER BY
DISPLAY_NAMEOr just by software name:
SELECT
DISPLAY_NAME,
COUNT(*) AS INSTALLED
FROM
(
SOFTWARE,
MACHINE_SOFTWARE_JT,
MACHINE,
MACHINE_LABEL_JT ML,
LABEL L
)
WHERE
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
AND MACHINE.ID = ML.MACHINE_ID
AND ML.LABEL_ID = L.ID
AND NOT IS_PATCH
AND L.`NAME` = 'WORKSTATIONS'
GROUP BY
DISPLAY_NAME
ORDER BY
DISPLAY_NAMERemember to change the label from 'workstations'
Posted by:
camrevard
12 years ago
Update:
I've created a new label called LABS in which all the desired computers are a part of. I see a report for finding a specific piece of software from within a label's machine list, but can someone assist me with creating a report that will return all software listed on computers in a specific label?
I've created a new label called LABS in which all the desired computers are a part of. I see a report for finding a specific piece of software from within a label's machine list, but can someone assist me with creating a report that will return all software listed on computers in a specific label?
Posted by:
camrevard
12 years ago
You sir, are a gentleman and a scholar.
Now out of the pure greedy impulse is it possible to do the same, but as a software count? More specifically, instead of listing all software installed pc by pc, can we somehow total the instances of software installed within a label? So if 5 computers within the label have cutepdf installed, the report tallies that as CutePDF : 5 etc?
Now out of the pure greedy impulse is it possible to do the same, but as a software count? More specifically, instead of listing all software installed pc by pc, can we somehow total the instances of software installed within a label? So if 5 computers within the label have cutepdf installed, the report tallies that as CutePDF : 5 etc?
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.