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
0 Comments   [ + ] Show Comments

Comments

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
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?
Answered 03/02/2012 by: camrevard
Orange Senior Belt

Please log in to comment
2
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.
Answered 03/02/2012 by: dchristian
Red Belt

Please log in to comment
0
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?
Answered 03/02/2012 by: camrevard
Orange Senior Belt

Please log in to comment
2
Here's a detailed version by Name, version and vendor.
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_NAME

Or 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_NAME


Remember to change the label from 'workstations'
Answered 03/02/2012 by: dchristian
Red Belt

Please log in to comment
0
Thank you Dave! Very impressive!
Answered 03/02/2012 by: camrevard
Orange Senior Belt

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