Security

last person joined: 3 days 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 Sep 24, 2021 11:59 AM
      |   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 Sep 25, 2021 04:00 AM
    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 Sep 28, 2021 12:24 PM
      |   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 Sep 29, 2021 02:50 AM
    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 Oct 01, 2021 10:16 AM
    That fixed it thanks for your help.

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