8 Replies Latest reply on Feb 13, 2017 9:11 AM by Gjstewart

    Custom Data where you can use GetDate() like LANDesk date information

    Gjstewart Specialist

      Hi has anyone entered date information into a custom field using the custom fields in the registry and then been able to use the

       

      GetDate() function in the landesk query editor ?

       

      We thought we could just change the METAATTRIBUTES DATATYPE for our new custom field to DATETIME but it still wont work.

       

      update METAATTRIBUTES

      Set DATATYPE = 'DATETIME'

      Where METAATTRIBUTES_IDN = 2814

       

      ( where 2814 is the IDN of our new custom field )

       

      I want to be able to run a query in landesk console against a custom field with a DATETIME in it and get a result based on todays date.

       

      So results based on last 2 days or 24hrs or 30 days....

       

      like you can with the inventory scanner as detailed here.

       

      How to query for devices updated by Inventory since X