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)
0

Hello,

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?

0

Yes it is the coliumns in the report

0

Hello,

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?

0

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 (201k 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
try
{
    $compareDate = $Context.TargetObject.Get($property)    
}
catch
{
    $Context.ConditionIsMet = $False
    return
}

# 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.5k points)
0 votes
1 answer

We have four OUs in Active Directory (Pending Deletion, Disabled with Mail Delegates, Disabled with HR Extensions and Disabled_Temp_Leave) that users are moved to prior to their eventual ... past 7 days have been moved to one of 4 of these OUs. Thanks!

asked Jun 3 by RayBilyk (120 points)
0 votes
1 answer

Hello how is it possible to get the IPv4 address in "All Computers" report? regards Helmut

asked May 31 by a423385 (450 points)
0 votes
1 answer

I have a report that has a Multi-valued field of "Other-Login-Workstations". It only displays one of the values in the report. My report has the following fields: ... -Workstations How do I go about displaying all the values of "Other-Login-Workstations"?

asked Mar 31 by rurbaniak (1.4k points)
2,491 questions
2,238 answers
6,010 comments
397,752 users