10 Replies Latest reply on Sep 26, 2018 11:26 AM by terry_mitch

    Servers added in the last 12 month Report

    terry_mitch

      Hi there,

       

      I have been given the task of running a report to show servers that have been added in the last 12 months. Is this possible? If it is, would you then be able to add anything else to it, such as say, disk usage?

       

      Rgds,

       

      Terry

        • Re: Servers added in the last 12 month Report
          David Smith

          Hi Terry,

           

          I assume you mean servers added to SolarWinds? The Auditing Event table would show a log of all new Nodes added for as long as you keep that information (Check your retention settings). Then you would need to run a query to correlate the information with something like the Volumes table so that it could show you all nodes added and then the disk usage of the volumes for those nodes. However, the Volumes table would give you disk usage for the server at the time of running the report, not a historical view.

           

          Another option could be that you set up an alert o notify you whenever a Node is added, and then you correlate that information offline.

           

          Hope that points you in the right direction if you get stuck come back to me.

           

          Cheers

          David

          1 of 1 people found this helpful
            • Re: Servers added in the last 12 month Report
              terry_mitch

              Thanks David,

               

              That has pointed me in the right direction. I think I am now getting stuck with the query part, I can create a report just showing Nodes added from the last 12 months fine. How would I run the query that would allow me to also show disk space on said servers?

               

              Terry

               

              Terry Mitchinson

              IT Support Analyst

              T: +442088146619

              M: +447876258293

              E: Terry.Mitchinson@firstrate.co.uk

               

              First Rate Exchange Services Ltd.

              Great West House. Great West Road. Brentford.  TW8 9DF

              www.firstrate.co.uk

              The experts in foreign exchange

               

              Data Classification: Amber - Internal

              • Re: Servers added in the last 12 month Report
                terry_mitch

                Actually, just checked it again and that doesn’t necessarily work how I would like. It picks up everything like Printers :s

                 

                Maybe there are better options on the Legacy Report Writer?

                 

                Terry Mitchinson

                IT Support Analyst

                T: +442088146619

                M: +447876258293

                E: Terry.Mitchinson@firstrate.co.uk

                 

                First Rate Exchange Services Ltd.

                Great West House. Great West Road. Brentford.  TW8 9DF

                www.firstrate.co.uk

                The experts in foreign exchange

                 

                Data Classification: Amber - Internal

              • Re: Servers added in the last 12 month Report
                adam.beedell

                Hi Terry,

                 

                Definitely doable.

                As David mentioned the Audit log is the 'ideal' place to search, however 12month retention on events would probably kill your DB. Perhaps worth scheduling it monthly.

                 

                A way of doing it historically would be report on any constant historical statistic (status maybe) for Vendor = Windows and display the oldest statistic found along with the timestamp collumn (minimum in legacy report writer), you could then link drive stats and anything else relevant.

                You absolutely would run into problems that way with nodes that were readded or something like that. Not sure what unmanaged statuses would do to it either.

                1 of 1 people found this helpful