Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

API Poller variable storing seems to do data conversion? Azure AD Poller template.

Hi folks,

Come across an oddity while testing the Azure Active Directory API poller. The first component in the poller uses onPremisesSyncEnabled and onPremisesLastSyncDateTime which returns:

onPremisesSyncEnabled : true

onPremisesLastSyncDateTime : 2024-03-13T15:26:53Z

The Last Sync is perfect for using as a variable called EXPECTED_SYNCTIME that's used in subsequent calls to trace possible sync failures. However, when you add that value as a variable it gets converted into a string date/time like this:

3/13/2024 3:26:53 PM

Has anyone come across this behaviour before and managed to do something with it? I wonder why it's converted and not left as is.

Cheers

Adrian

Find more posts tagged with

Accepted answers

All comments

adam.beedell

Yeah this is annoying and limiting and tends to create the need to rebuild in SAM

adam.beedell

@fop if you can store the string (If) then you can probably force it back to a datetime in a SWQL/SQL/code function

fop

I suppose it's not an absolute showstopper since I can do it in SAM as you say, but I do wonder why SW thought it 'might be handy' if the date was converted to a more human friendly string with no way of converting it back. Our test env is running 2024.1 so I'll try it there just in case the devs came to their senses in between versions