CM07/CM12 would have no way of knowing when a user was added into a security group. This is really an AD question and I don’t think there is a way to get this data without 3rd party tools like OpsMgr ACS and that assume that you have been collecting the data for a while.
From: [email protected] [mailto:[email protected]] On Behalf Of Bogdan Radu Sent: Wednesday, August 21, 2013 9:07 AM To: [email protected] Subject: Re: [mssms] ConfigMgr Report for user Groups Hey Daniel, What I need is an exact start date when the user was added to a certain group, and I need ( if possible ) all the groups that user belongs to. That ID it’s just a number, I don`t really need it. Thank you. From: Daniel Ratliff <mailto:[email protected]> Sent: Wednesday, August 21, 2013 3:20 PM To: [email protected] Subject: RE: [mssms] ConfigMgr Report for user Groups What is the Start Date and End Date? Is that HR data you already have in another db? Do you want to list all groups the user is a member of? Is the ID a special number tied to the account or do you just want an index for the users? Do you already have a query you have wrote? Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Bogdan Radu Sent: Wednesday, August 21, 2013 8:09 AM To: [email protected] Subject: [mssms] ConfigMgr Report for user Groups Hello, I would like to create a report pretty much like this: Id Account Group Start_Date End_Date 1 Domain\user.1 Group1 2010-06-16 00:00:00.000 2010-12-13 00:00:00.000 2 Domain\user.2 Group2 2012-02-01 00:00:00.000 2013-02-01 00:00:00.000 Can anyone help ? Thank you, Greetings. Bogdan Radu. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
