Use last logged on date to find email people that have not logged into AD in X number of days

May 1, 2013 at 4:21 PM
I am using the ActiveDirectory IP and the Get Object, but I haven't figured out how to actually make it give me only the people that have not logged into the domain in x number of days. I am pulling the names from a security group (no problem) but not successful with the rest.

Any assistance would be greatly appreciated.

Note: In the diagram, the "Append Line" is only for troubleshooting.

Image
May 13, 2013 at 2:37 PM
This might be a perfect scenario to leverage PowerShell. Plop in a PowerShell script into the Orchestrator Workflow. Publish the data PowerShell needs to query on the bus, let the ActiveDirectory module query that data instead and republish the extra values (like LastloggedOnDate) to the Bus and leverage from there.

I was trying to do something similar in Orchestrator but the present Integration Packs don't seem to return this data to consume it.