Send netdisco-users mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:

   1. Netdisco Reports question (Muris)
--- Begin Message ---
Hi,

 

Im trying to do a web report for the following SQL query which lists devices 
recently added into net disco for past 2 weeks

 

netdisco-do psql -e "select ip, name from device where creation > now() - 
interval '2 weeks'"

 

In the deployment YML I have something like this, which doesn’t work, any ideas?

 

- tag: recent     

    label: 'Recent Devices Added past 2 weeks'

    category: Device

    columns:

      - {ip: 'Device IP'}

      - {name: 'Device Name'}

    query: |

      SELECT ip, name,

      FROM device

      WHERE creation > now() - interval '2 weeks'

      ORDER by name


--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to