I am looking for a report that I cannot seem to create. I am trying to replace the report that they have in the old version of reporter.
I have attached a report that I was working on that does the opposite of what I want (Changing the Text of the Default Values to remove Customer Information). It shows the users that are members and I need to know if they are not members of a few groups. It also appears that the "Not in the next" operator does not work properly as I get no results. I would expect that objects that have no expiry as well as objects that have expires after 90 days would show up in the report.
Any help is appreciated.
I want to know what users that meet the following conditions:
Are in the Specified Domain
Title is not "String"
Expiration date is more than "X" days ago
Are not disabled
That are not members of the following groups
Group1
Group2
Group3
The group list needs to be modifiable and should be selectable Are or Are not members
Disabled Flag should be selectable (enabled or disabled)
Domain needs to be Modifiable
Title needs to be modifiable with multiple operators if possible (Is, Is Not, Contains, Does not Contain)
Expiration Date needs to be adjustable
The following user attributes are needed in the report:
AccountID
whenChanged_Ext
EmployeeID
Title
EmailAddress
AccountExpirationDate
AccountName
AccountIsDisabled
FriendlyName
Department
Description
FullName
PasswordIsExpired
PasswordLastChanged
WhenCreated
LastLogon
LastLogonTimestamp
LastName
FirstName
Company
ManagedBy
UserOU
Office
extensionAttribute11_Ext