Security

 View Only
last person joined: yesterday 

Forum to discuss Enterprise security using HPE Aruba Networking NAC solutions (ClearPass), Introspect, VIA, 360 Security Exchange, Extensions, and Policy Enforcement Firewall (PEF).
Back to discussions
Expand all | Collapse all

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

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?

    EMPLOYEE
    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
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message


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

    EMPLOYEE
    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
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message