Client Management Suite

 View Only
  • 1.  Raw Sql request: Unmanaged computers based on ipaddress.

    Posted Jun 13, 2012 07:11 AM

    Hello.

    I am looking for the raw sql to produce reports of unmanaged objects/computers based on subnet. Please could you help me with the code for this.

     

    The end result that I am aiming for with this is to produce reports that can be exported into excel of any umnanaged devices that we have on our local site and in our remote sites.

     

    Thanks in advance.



  • 2.  RE: Raw Sql request: Unmanaged computers based on ipaddress.

    Posted Jun 20, 2012 03:35 PM

    What is the data source for this report?  Are you performing network discovery, AD import, import from .csv, none of the above, or something else?



  • 3.  RE: Raw Sql request: Unmanaged computers based on ipaddress.

    Posted Jul 05, 2012 10:00 AM

    Hello.

    I am using network discovery as a data source. I have custom discovery jobs configured to scan each subnet of our network each week to report back new devices.