AD Action Summary Custom Report Request

An overview explaining the report you require:
I need a report that creates a summary of AD activity, showing Accounts Created, Accounts Deprovisioned, Computers Created, Groups Created and Groups Modified.
I have reports that will output the information but then I need to use another method to count the number of operations then find another way to send the information.
It would be much easier if a custom report could be created that I could then use the scheduler to send the email with the information.

The report will output the information like this:
Action                                      Count
Accounts Created                    163
Accounts Deprovisioned          431
Computers Created                 133
Groups Created                       361
Groups Modified                      1502

What version of Enterprise Reporter is being used?:
3.1.0.2112

What discoveries have been run?:
AD

Is there a library report that closely matches what you require?:
Not that I have found but I have made one that gathers the information required just doesn't total the numbers. (see above)

What fields are required in the report?:
Accounts Created, Accounts Deprovisioned, Computers Created, Groups Created and Groups Modified

How does the information in the report need to be sorted?:
Just summary totals as shown above

What parameters are required for filtering the report?:
Timeframe selection e.g. Summary between 01/09/2019 and 01/10/2019

How will this report be consumed? For example, will the report be viewed in report display, exported to CSV, or exported to PDF?:
Preferably sent out using the scheduler but otherwise can be report viewer, csv or pdf etc.

Parents Reply Children
  • Thank you very much for sorting that Peter, it is exactly what we need.

    Both forms will be excellent for our needs.

    If it is simple to change would it be possible to have the date in UK format or something like this "01 February 2019".

    If it isn't an easy change don't worry I will just add a note to say it is in US format.

    Thanks once again for your help on this

    - Alain

  • For the way I had added the Date range in the report, there is no way to format that combined string into the format you require.

    However, you can replace that string with 2 individual Dates which can be formatted however you like.

    Edit the layout of the report, and remove the calculatedField1 from the layout. Then drag-and-drop the two date fields (Start of Range and End of Range) from the Fields List into the detail header band. 

    Once there, you can change the formatting for each of the dates by selecting each one and clicking the little chevron (>) to change the format string to {0:dd MMMM yyyy}

    Using the layout editor will let you position the controls however you like, as well as change other items like the formatting of the Page footer's date time.

    Peter

  • Perfect all sorted thank you very much for your help