8 Replies Latest reply on Mar 3, 2013 3:28 AM by gal sonnenfeld

    QueryURL- ADDM

      Share This:

      I have built a script, and it should run an ADDM query using QueryURL.

      But it doesn't work because the URL is too long.

      What can I do to make it shorter?

       

      QueryURL1=http://SERVER_XYZ/ui/api/CsvApi?var=SEARCH+DiscoveryAccess+WHERE+%28discovery_starttime+%3E+currentTime%28%29+-+%281+*+864000000000%29%29+PROCESS+WITH+WHERE+%28state+%3D+%27Finished%27+AND+result+%3C%3E+%27Success%27+AND+NODECOUNT%28TRAVERSE+Next%3ASequential%3APrevious%3ADiscoveryAccess+WHERE+state+%3D+%27Finished%27+AND+result+%3C%3E+%27Success%27+AND+NODECOUNT%28TRAVERSE+Next%3ASequential%3APrevious%3ADiscoveryAccess+WHERE+result+%3C%3E+%27Success%27+AND+state+%3D+%27Finished%27+AND+NODECOUNT%28TRAVERSE+Next%3ASequential%3APrevious%3ADiscoveryAccess+WHERE+result+%3D+%27Success%27+AND+state+%3D+%27Finished%27+AND+NODECOUNT%28TRAVERSE+DiscoveryAccess%3ADiscoveryAccessResult%3ADiscoveryResult%3ADeviceInfo+WHERE+NOT+hostname+HAS+SUBSTRING+%27pc%27+AND+NOT+hostname+HAS+SUBSTRING+%27lapt%27%29%29%29%29%29+SHOW+%23Next%3ASequential%3APrevious%3ADiscoveryAccess.%23Next%3ASequential%3APrevious%3ADiscoveryAccess.%23Next%3ASequential%3APrevious%3ADiscoveryAccess.%23DiscoveryAccess%3ADiscoveryAccessResult%3ADiscoveryResult%3ADeviceInfo.hostname+AS+%27Hostname%27%2C+endpoint%2C+reason%2C+device_summary%2C+end_state%2C+result%2C+state%2C+discovery_starttime%2C+discovery_endtime%2C+%23Next%3ASequential%3APrevious%3ADiscoveryAccess.discovery_starttime+AS+%27Previous+Discovery+Start+Time%27%2C+%23Next%3ASequential%3APrevious%3ADiscoveryAccess.discovery_endtime+AS+%27Previous+Discovery+End+Time%27%2C+%23Next%3ASequential%3APrevious%3ADiscoveryAccess.result+AS+%27Previous+Result%27%2C+%23Next%3ASequential%3APrevious%3ADiscoveryAccess.state+AS+%27Previous+State%27%2C+%23Next%3ASequential%3APrevious%3ADiscoveryAccess.%23Next%3ASequential%3APrevious%3ADiscoveryAccess.discovery_starttime+AS+%27Pre-+Previous+Discovery+Start+Time%27%2C+%23Next%3ASequential%3APrevious%3ADiscoveryAccess.%23Next%3ASequential%3APrevious%3ADiscoveryAccess.discovery_endtime+AS+%27Pre-+Previous+Discovery+End+Time%27%2C+%23Next%3ASequential%3APrevious%3ADiscoveryAccess.%23Next%3ASequential%3APrevious%3ADiscoveryAccess.result+AS+%27Pre-+Previous+Result%27%2C+%23Next%3AS&username=XYZ&password=XYZ

       

      Thank you!