Admin Rights and Installed Software

[slice16]

Hello All,

 

I am wanting to create a monthly report that queries all machines where a standard users has admin rights (a query that will look at the default admin groups and report back the ones that don't meet these) and any new software that has been installed on that machine in the last month.

 

From what I can see, there isn't a report that shows admin rights, but there is one that shows 'changes' to the machine. Will I need to create a custom report (maybe using SQL views). If so, what tables/keys should I be linking?

 

Thanks,

 

Paul

[Eswar Koneti]

Hello All,

 

I am wanting to create a monthly report that queries all machines where a standard users has admin rights (a query that will look at the default admin groups and report back the ones that don't meet these) and any new software that has been installed on that machine in the last month.

 

From what I can see, there isn't a report that shows admin rights, but there is one that shows 'changes' to the machine. Will I need to create a custom report (maybe using SQL views). If so, what tables/keys should I be linking?

 

Thanks,

 

Paul

 

 

Did you try this http://myitforum.com/cs2/blogs/skissinger/archive/2008/06/08/report-on-local-administrators-group-membership-updated.aspx ?

[slice16]

Did you try this http://myitforum.com/cs2/blogs/skissinger/archive/2008/06/08/report-on-local-administrators-group-membership-updated.aspx ?

 

Hi Eswar,

 

That is exactly what I was looking for. It has worked a treat, thanks

 

Kind Regards,

 

Paul