Query to Retrieve newly Registered Clients (MP_ClientRegistration)
Hello Guys, How can i query clients that just registered for the past number of days (e.g 30 days) I want to use the MP_ClientRegistration Agent and Date under System Resource Thanks!
January 19th, 2010 5:54pm

That should to the trick: SELECT v_AgentDiscoveries.AgentTime, v_R_System.Name0FROM v_AgentDiscoveries INNER JOINv_R_System ON v_AgentDiscoveries.ResourceId = v_R_System.ResourceIDWHERE (v_AgentDiscoveries.AgentName = 'MP_ClientRegistration'and Datediff(day, v_AgentDiscoveries.AgentTime, getdate()) < 30)
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2010 6:17pm

Try pasting this into your collection queryselect * from SMS_R_System where SMS_R_System.AgentName = "MP_ClientRegistration" and datediff(day,SMS_R_System.AgentTime,getdate()) < 30nick
January 19th, 2010 11:18pm

thanks guys, bot queries are going to be useful for me. votes for you.
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2010 12:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics