Security

last person joined: 6 hours ago 

Enterprise security using ClearPass Policy Management, ClearPass Security Exchange, IntroSpect, VIA, 360 Security Exchange, Extensions and Policy Enforcement Firewall (PEF).
Expand all | Collapse all

How do I compare Intune last update date and time to longer then one year?

Jump to Best Answer
This thread has been viewed 21 times
  • 1.  How do I compare Intune last update date and time to longer then one year?

    Posted 26 days ago
      |   view attached
    What would the syntax be for verifying the Intune attribute for last time Intune updated. I know it would be comparing time authorization time source. I don't see a drop down for one year. 



    ------------------------------
    Kelly L
    ------------------------------


  • 2.  RE: How do I compare Intune last update date and time to longer then one year?

    Posted 25 days ago
    Update the [Time Source] Data-Time query and add "date_trunc('hour', localtimestamp(0)+ interval '1 year') as one_year".



    ------------------------------
    SANDEEP YADAV
    Global Escalation Center, ACCP
    ------------------------------



  • 3.  RE: How do I compare Intune last update date and time to longer then one year?

    Posted 22 days ago
      |   view attached
    Doesn't seem to be working it denies authentication even though the Intune last update is less then one year from the time source. Does this look like the correct syntax? 


    ------------------------------
    Kelly L
    ------------------------------



  • 4.  RE: How do I compare Intune last update date and time to longer then one year?
    Best Answer

    Posted 21 days ago
    HI,

    Try updating the one-year query as below

    date_trunc('hour', localtimestamp(0)- interval '1 year') as one_year

    ------------------------------
    Nimal Varampetran
    ------------------------------



  • 5.  RE: How do I compare Intune last update date and time to longer then one year?

    Posted 19 days ago
    That fixed it thanks for your help.

    ------------------------------
    Kelly L
    ------------------------------