none
Reports SCCM RRS feed

  • Pregunta

  • good morning,
     I have a report where I would like Included a field, show me the IP address of the teams that I listed.

     I can not make it work. Besides the fields that I have I want to show me the last IP address of each computer.

    The text odf the report is:

     

    select  distinct 

     v_R_System_Valid.ResourceID, 

     v_R_System_Valid.Netbios_Name0 AS [Computer Name],

     v_GS_SYSTEM_ENCLOSURE_UNIQUE.SerialNumber0 AS [Serial Number],

     v_R_System_Valid.User_Name0 AS [Last Logon User],

     v_GS_COMPUTER_SYSTEM.Model0 AS [Model],

     [Top Console User] = CASE 

     when (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 is NULL or v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 = '-1') 

     then 'Unknown' 

     Else v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 

     End, 

     v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System], 

     v_GS_OPERATING_SYSTEM.CSDVersion0 AS [Service Pack Level]

    from v_R_System_Valid 

     inner join v_GS_OPERATING_SYSTEM on (v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) 

     left join v_GS_SYSTEM_ENCLOSURE_UNIQUE on (v_GS_SYSTEM_ENCLOSURE_UNIQUE.ResourceID = v_R_System_Valid.ResourceID) 

     inner join v_GS_COMPUTER_SYSTEM on (v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) 

     inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_R_System_Valid.ResourceID)  

     left join v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP on (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.ResourceID = v_R_System_Valid.ResourceID)

    Where v_FullCollectionMembership.CollectionID = @CollectionID 

     Order by v_R_System_Valid.Netbios_Name0

     

     

    And de Prompts:

    begin

     if (@__filterwildcard = '')

     select v_Collection.CollectionID, v_Collection.Name from v_Collection order by v_Collection.Name

    else

     select v_Collection.CollectionID, v_Collection.Name from v_Collection

     WHERE v_Collection.CollectionID like @__filterwildcard

     order by v_Collection.Name

    end

     

     

    Thanks in advance


    Alvaro Mancera
    lunes, 23 de enero de 2012 9:54