0 votes

I am in need of a way to email a csv of everyone who's EmplyeeHireDate (AD feild) is in the current month but not in this year. I will need to have the ablity to define which AD fields I use. I am going to need to have this export send monthly. I searched the repo but did not find anything. Has one already been written?

by (1.2k points)


It can be done by creating and then scheduling a custom report. For us to help you with the report, please, specify what exactly you mean by define which AD fields I use. Is it about the columns to be present in the report?


Yes it is the coliumns in the report



Thank you for clarifying. It can be done using a custom report. The report can be available for manual generation in the Web interface and Administration console. Also, you can schedule the report delivery (e.g. as a CSV file via email). In the latter case, you will be able to predefine the columns that will be present in the delivered report. Does this approach meet your needs?


How to I create it to include every account that has a Hire Date with in the current month but not in the current year?

1 Answer

0 votes
by (206k points)

Hello, To create the report:

  1. Launch Adaxes Administration console.
  2. In the Console Tree, right-click your service node.
  3. In the context menu, navigate to New and click Report. image.png
  4. Specify a report name.
  5. In the Generate the report using section, keep the Active Directory search option selected. image.png
  6. Click Next.
  7. Click New.
  8. Click Next twice.
  9. Click Finish.
  10. Click Next three times.
  11. In the Search filter field, enter the following: (sAMAccountType=805306368)
  12. Click Exclude below (it will change to Include). image.png
  13. Click Add Condition. image.png
  14. Select If PowerShell script returns true.
  15. Paste the below script into the Script field. In the script, the $property variable specifies the LDAP name of the Hire Date property.
$property = "adm-CustomAttributeDate1" # TODO: modify me

# Get attribute value
    $compareDate = $Context.TargetObject.Get($property)    
    $Context.ConditionIsMet = $False

# Compare dates
$currentDate = [System.DateTime]::UtcNow
$Context.ConditionIsMet = ($compareDate.Month -eq $currentDate.Month) -and ($compareDate.Year -ne $currentDate.Year)

image.png 6. Enter a short description and click OK. 7. Click Next and finish creating the report.

For information on how to schedule reports, have a look at the following tutorial: https://www.adaxes.com/tutorials_ActiveDirectoryManagement_ScheduleReports.htm.

Related questions

0 votes
1 answer

Will Dynamic forms in Web Interface be included in this release? We are in the midle of deploying the solution and the dynamics web forms will be a game changer for us.

asked Jun 16, 2020 by jurbina (20 points)
0 votes
1 answer

"Connecting to remote server <<FQDN Servername>> failed with the following error message : The server certificate on the destination computer (<<FQDN servername: ... ? This may help to diagnose the issue with schannel on the skype server.

asked Mar 5, 2020 by mark.it.admin (1.6k points)
0 votes
0 answers

It would be great if we could run a report on an OU and get the following information: Computer Name Local Accounts Whether or not the account is an administrator ... this is less important. Thanks in advance. Your support team is great and appreciated.

asked Sep 8 by mikek (80 points)
0 votes
1 answer

For example, if the scope is a specified OU, running the report will list management history for every object in the OU even if it has had no management operations ... so objects that have not had any recent modifications are excluded from the report results?

asked Aug 13 by ryan741 (70 points)
0 votes
1 answer

Hi support, I have created a new report with 'Existing report with specific parameters' checked under Generate report using section. I am re creating 'Password Never Expire' ... from report. Not sure what I am missing here, any help would be appreciated.

asked Jul 28 by Vish539 (100 points)
2,552 questions
2,295 answers
641,751 users