Version 3

    All Currently unmanaged devices + time period. States when, For how long, What time Remains, a Time/Date stamp (From-Until), and by what account.


    NODE:                        WHEN:               FOR:          REMAINS:            FROM                                            UNTIL                                                ACCOUNT

    SolarWindsNode1       10 Days ago       21 Days     11 Days                 9/6/2017 6:48:45 12:00:00 AM      9/27/20177 6:48:45 12:00:00 AM       SolarWIndsUser1



    Retested and confirmed a working SQL Query. Tested on NPM 12.1.