Post reply

Modify object variable

  • November 5, 2007 at 11:56 pm

    #119165

    Hi,

    I use a WMI data reader task to execute the following query

    “Select DeviceID , freeSpace, size from Win32_LogicalDisk where freeSpace is not null”. The result is placed in a variable of type object. I now need to add the server name to the output produced. I tried to do “select ‘servername’, deviceid,..”,but that does not work. Is there any way to add it to the object variable?

  • November 6, 2007 at 12:21 am

    #748529

    ...Use SERVERPROPERTY('ServerName')

    If you've multiple instances, you might want to use SERVERPROPERTY('InstanceName')

    --Ramesh

  • November 6, 2007 at 1:13 am

    #748543

    The problem I have is not getting the server name, it is adding the name of the server to an existing dataset, which in this case was the object variable returned by the WMI task.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply