Hi all,
I have a simple SQL job which runs every hour to put any any agent managed
computer which was deleted into a separate table.
I would like to extend this to say who removed the windows agent computer.
Is this possible and can anyone help? We use this table for audit puroses and
without the 'who' it becomes pretty useless.
INSERT INTO myDB.dbo.ObjectDeletion
(DeletedObjects , LastModified )
select
TargetMonitoringObjectDisplayName as 'DeletedObjects' , LastModified
from RelationshipGenericView
where isDeleted=1
AND SourceMonitoringObjectDisplayName = 'Agent Managed Computer Group'
Peter Hakesley | Monitoring & Automation Technical Lead Engineer, Data Centre
Services
t: +44(0)845 155 6556 ext: 4006
e: [email protected] | w: www.scc.com<http://www.scc.com/>
a: SCC, CV1, Cole Valley, 20 Westwood Avenue, Tyseley, Birmingham B11 3RZ
