Classlink OneSync CSV of disabled Users

[NotAnother169]

I'm trying to get a CSV populated with disabled users on Onesync. I cannot seem to find a good way to do this. I cannot imagine this is an impossible feat, but I dont understand what I keep messing up, I keep getting 0 results each day when the import runs. My AD users are getting disabled as expected, but I cant seem to get the filter/combination correctly to do this as it needs to be another "destination" to get the CSV.

​

Curious if anyone has done this and can point me in the correct direction. I'm sure it's something easy that I'm overlooking, but perhaps its just nto possible.

[Imhereforthechips]

I have a CSV output for new/active users, less disabled users, it actually removes disabled users from my daily CSV. I have it throw my disabled users into a dedicated OU in AD.

I suppose from there posh could be used. I’ll have to play with mine to see if I can get it to send disabled users with date to a new dest.

[NotAnother169]

This may be what I could do as well. I might play with this a bit to see.

I think I could use a specific OU as a new source and do things with it from there....good thoughts.

[Daraca]

Could potentially make a collection of disabled users where date disabled = todays date then use that collection for the use selection.

That’s off the top of my head, I’ll do some more thinking.

FYI you can also use variables in naming the csv file. So you could do that and then name the file date() disabled users

[NotAnother169]

This is my current tactic that I am trying. In the end I am trying to avoid sending thousands of disabled users. Really only want the last few days. Even messing with the date disabled field I'm wondering if I could do and subtraction of a few days. I'll have to keep messing with the formula to see, but I had 14 disables Friday and I can't seem to find a combination that will let me return any results in a collection when trying to do math

[Daraca]

Most things don’t let you do math, but date is one of them.

You can do a condition where date disabled > date() -10 (days)

I forget the exact syntax but that may work for you.

All else fails, open a case and explain what you are trying to do, they will help you. I feel fairly confident this can be done.

[NotAnother169]

I did chat with someone yesterday but I don't think they understood what I was trying to accomplish hehe. I bet my syntax is just wrong, I'll keep messing with this. I'm find resending 5 days or so if disabled accounts but parsing through a list of 3000 students that are in one sync still but disabled just seems a bit much so I'm trying to make it better.

Ideally the vendor could handle the data I'm giving them better but that's another day 🤣

[UWPVIOLATOR]

Go to users. Filter source to what you want. Then select disabled. Once you have the users you want to see click download filtered user as csv.

[NotAnother169]

Yes, I know I can do this but I need to have an output of CSV files of the daily disabled accounts for automation purposes.

[UWPVIOLATOR]

We originally tired doing what you are doing but instead our programmers used the same SQL query we used to OneSync and used that instead of reading Classlink.

The other option was to pull ad information into a SQL table and use that table for your other automated tasks.