SQL - Bulk update Interface Statistics interval

That's basically correct, but you don't do it with an "update where" query - SWQL only does SELECT. To modify the data, first get the Uris of the objects to modify, then call an Update operation on them. In PowerShell you do this via the Set-SwisObject cmdlet. Something like this:

$swis = Connect-Swis [connection options go here]

$uris = Get-SwisData $swis "SELECT Uri FROM Orion.NPM.Interfaces WHERE NodeID=@nodeid" @{nodeid=1234}

$uris | Set-SwisData $swis @{StatCollection=30}

Ah ok, I was just going to do it from SQL Server Query, but I will make this a API script and do it as you demonstrated.

Thanks Tim.

This isn't working and I have no idea why........

    #!/usr/bin/perl

    use SOAP::Transport::HTTP;

    use XML::Simple;

    use SW::Orion;

    use SW::InformationService;

    use strict;

    my $hostname = '10.224.254.203'; # fill in a hostname

    my $username = 'XXXX';

    my $password = 'XXX';

    my $endpoint = "https://$hostname:17778/SolarWinds/InformationService/OrionBasic";

    my $xs = XML::Simple->new();

    my $swis = SW::InformationService->new();

    $swis->outputxml('true');

    $swis->proxy($endpoint);

    $swis->proxy->http_request->authorization_basic($username, $password);

       print "Startign\n";

       my $response = $swis->Update('swis://$SWHost/Orion/Orion.Nodes/NodeID=33104/Interfaces/InterfaceID=101366',  {'StatCollection'=>'30'});

     return if ($response eq '<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><log xmlns="http://schemas.solarwinds.com/2007/08/informationservice"/></s:Header><s:Body><UpdateResponse xmlns="http://schemas.solarwinds.com/2007/08/informationservice"/></s:Body></s:Envelope>');

       print $response;

*******************************************************************************

ERROR:

Use of uninitialized value $_[0] in pattern match (m//) at /home/autoeng/lib/perl5/SOAP/Lite.pm line 340.

~

where is $SWHost defined?

This won't throw an error because you have it in single quotes, and so the first argument contains that string literally, instead of what you want, which is probably localhost

i.e.:

"swis://localhost/Orion/Orion.Nodes/NodeID=33104/Interfaces/InterfaceID=101366"

/RjL