Recent content by jefrowski

Hi guys, I need to alter the computer description field of all of the PC's I look after, they have all been named using the same format, therefore, I do not know which PC belongs to which department, i.e WORKST1234, WORKST1344, etc, I figured by changing the computer description I can manage...

Hi guys, I have a weird issue, alot of the PC's on the network are named with the same convention, ie. comp1234, comp1235, etc. I need to find a solution to identify which PC belongs to which department, which I think I will do by changing the computer description field? Visiting each PC...

Hi Mich, After hours of trying to learn sql joins, I came up with this one: SELECT Caption0 as C054, sf.filename as Department, COUNT(*) AS 'Count' FROM v_GS_OPERATING_SYSTEM OPSYS inner join v_gs_softwarefile sf on OPSYS.ResourceID=sf.ResourceID where sf.filename like 'sales.exe' GROUP BY...

Hi Mich, The only change I have made to the query was to change the filename to sales.exe? I tried as an experiment to change the filename to word.exe, and the numbers that came back were believable?? I am rather confused as to why when I change the filename to sales.exe that is is coming back...

Hi Mich Thanks for helping out! Now, I have a slight issue! You mentioned that it may report all exe files? I think that it what is happening, and also mentioned a unique identifier for each file? Could you explain this for me? I have sales.exe, hr.exe, etc, but the numbers it reports in the...

Hi Mich, Thanks ever so much for your help! The first report works fine, the second one is just the kind of thing I am after, but is returning crazy number in the count column!! I'll have a good play around with it!! The way I used the files was to name them sales.exe, hr.exe and copy the file...

Thanks for helping out Mich! OK: Using our login scripts I have the script copying an exe file onto the users PC, depending on which group they are in (i.e HR, Sales, etc), just like you presumed! I now need to create a report that breaks down the following: a:/ How many PC's per department...

Hi guys, Can I ask some advice? I need to create a report that will show: Count of PC's by department, and how many of each operating system live in each department? So far I have copied an exe onto each client that shows which department they are in, i.e HR, Sales, etc, but now I need to...