Endpoint Protection

 View Only
Expand all | Collapse all

export unmanaged and unknown computers

Fatih Teke

Fatih TekeJun 09, 2009 01:50 AM

Fatih Teke

Fatih TekeJun 09, 2009 04:11 AM

  • 1.  export unmanaged and unknown computers

    Posted Jun 08, 2009 04:35 AM
    Hi everybody.
    I use "Find unmanaged computer" for find unmanaged and unknown computers. Is there any way to export result to excel file ? 175 computer is unknown but some of them is network  printer or network drive etc.
    please don't say use "unmanaged detector" because i have  vary much ip range  and I don't know how can i use it :( i read one paper but i am not sure i configure it success.
    Have a nice day.


  • 2.  RE: export unmanaged and unknown computers

    Posted Jun 08, 2009 05:23 AM
    Hi

    There is no option for the export list. Theption was there in SAV CE but in SEP it is unavailable. U must be knowing about the network devices so you can exclude those and deploy the rest.

    Ajit


  • 3.  RE: export unmanaged and unknown computers

    Posted Jun 08, 2009 08:17 AM
    Hello Ajitjha
    I know my network devices. but I want to copy result to excel sheet and send e-mail to my boss " There is 175 computers need to install sep and you can see these computers in attachment.
    well i think so i will write it with my hand :(


  • 4.  RE: export unmanaged and unknown computers

    Posted Jun 08, 2009 08:20 AM
    I use a VBSCript that checks for installed apps - I tell it to check for SEP.
    It returns a TXT file with installed, not installed, or unavailable.
    I import the text file into excel, sort, delete the installed nodes, save the rest and ship it off to my boss in an email.


  • 5.  RE: export unmanaged and unknown computers

    Posted Jun 08, 2009 08:33 AM
    can you send it scritp and teach me how can i use it plase
    Have a nice day


  • 6.  RE: export unmanaged and unknown computers

    Posted Jun 08, 2009 08:44 AM
    I can paste it here, might be better as a file - will look into that............I'll see about making this an upload or something to share with all.
    It's VERY handy. Please note that I didn't write the script, someone else did. His email is in the script. I left all that intact out of respect for HIS work. If you like it, drop him a note.

    I launch the VBScript from a batch file - that way I can easily redirect the output.

    This is the batch file:
    cscript is-it-installed-PerfectDisk.vbs>pd8-5-30-08.txt

    I was having the script below look for Perfect Disk disk defrag installs, and redirected output of the script  - and the cscript ensures the script is launched using cscript!

    This is the script (change sAPplication to = the software you wish to look for - EXACTLY as it's shown in the add/remove programs list in Windows - CASE sensitive!) Please note copyrights!

    ' Script gets list of workstations from the domain.
    ' Then pings workstation to see if it is alive.
    ' If it is alive, it attempts to search the registry under the Uninstall list for
    ' an application name you can specify at the top of the script.
    ' !!!!!!!! Use cscript to run from a cmd prompt otherwise you will get a bunch of popup dialogs for the output.
    ' For larger networks, pipe the output to a csv file and open with Excel so you can sort.
    ' Script by Matthew Jenkins (mattjenkins@mljenkins.com)
    ' Written on September 20, 2004
    '
    ' Set what application name you want to find here - name matches display name in add/remove programs list
    sApplication = "PerfectDisk"

    '
    ' Ignore errors (we get these if permissions is denied while querying a computer)
    On Error Resume Next

    ' Get computers from network
    Set objWMIService = GetObject("winmgmts:root\directory\ldap")
    Set colItems = objWMIService.ExecQuery("Select ds_cn, ds_location From ds_computer")

    ' Enumerate computers in network
    For Each oComputer in colItems
    sComputer = oComputer.ds_cn

    ' See if computer is available (returns ping) and if so then query for the application, otherwise return DISCONNECTED
    If(bIsAlive(sComputer) = true) Then
    iResult = iFindApp(sComputer, sApplication)
    If(iResult = 1) Then
    sInstalled = "INSTALLED"
    ElseIf(iResult = 2) Then
    sInstalled = "not installed"
    ElseIf(iResult = 3) Then
    sInstalled = "unable to query"
    End If

    Else
    sInstalled = "disconnected"
    End If

    WScript.Echo sComputer & vbTab & vbTab & sInstalled
    Next

    ' *******************************************************************
    ' Pass in a computername and application to search for
    ' Returns 1 on installed, 2 if not installed, 3 if the client cannot be searched (permissions errors, ...)
    Function iFindApp(sTargetHost, sApplication)
    On Error Resume Next

    ' Initialize some variables first
    iFindApp = 2
    sProgramName = ""
    sProgramVersion = ""
    sKeyPath = "SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\" ' key containing uninstall info

    ' Attempt to connect to client's registry
    Const HKLM = &H80000002 'HKEY_LOCAL_MACHINE
    Set oReg = GetObject("winmgmts:\\" & sTargetHost & "\root\default:StdRegProv")

    ' Ensure we connected ok to the client, if not just return false, it's probably not a valid Windows box
    If Err.Number <> 0 Then
    iFindApp = 3
    Exit Function
    End If

    ' Enumerate client registry looking for application
    oReg.EnumKey HKLM, sKeyPath, arrSubKeys ' get installed programs' subkeys
    For Each subKey In arrSubKeys ' get info from each installed program subkey
    ' attempt to get DisplayName
    If(oReg.GetStringValue(HKLM, sKeyPath & subKey, "DisplayName", sProgramName) <> 0) Then
    ' if no DisplayName try for QuietDisplayName
    oReg.GetStringValue HKLM, sKeyPath & subKey, "QuietDisplayName", sProgramName
    End If

    ' attempt to get DisplayVersion
    If(oReg.GetStringValue(HKLM, sKeyPath & subKey, "DisplayVersion", sProgramVersion) <> 0) Then
    ' if no DisplayName try for QuietDisplayName
    oReg.GetDWORDValue HKLM, sKeyPath & subKey, "VersionMajor", sProgramVersion
    End If

    ' If the name exists, return true
    If sProgramName = sApplication Then
    iFindApp = 1
    Exit Function
    End If
    Next
    End Function


    ' *******************************************************************
    ' Pass in host to ping
    ' Returns true if ping successful, false if ping unsuccessful
    Function bIsAlive(sTargetHost)
    sSourceHost = "." ' computer that will send ping requests, normally the local computer
    bIsAlive = False ' normally we will return false, unless ping is successful

    Set objWMIService = GetObject("winmgmts:\\" & sSourceHost & "\root\cimv2")
    Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_PingStatus WHERE Address = '" + sTargetHost + "'")

    For Each oRow In colItems
    If oRow.StatusCode = 0 Then
    bIsAlive = True
    End If
    Next
    End Function


  • 7.  RE: export unmanaged and unknown computers

    Posted Jun 08, 2009 08:52 AM
    Thank you very much. I will try this script. realy thank you.


  • 8.  RE: export unmanaged and unknown computers

    Posted Jun 08, 2009 10:00 AM
    Do u have fileshare.symantec.com   username and password? IF yes u can get the utility from there.


  • 9.  RE: export unmanaged and unknown computers

    Posted Jun 08, 2009 10:07 AM
    I've created a download if it's been approved.............


  • 10.  RE: export unmanaged and unknown computers

    Posted Jun 09, 2009 01:50 AM
    where can i download script?


  • 11.  RE: export unmanaged and unknown computers

    Posted Jun 09, 2009 02:32 AM
    i cannot logon to https://fileshare.symantec.com/ with my forum ID and password. Am I need another account for it? how can i be member this site?
    Thank you for help.



  • 12.  RE: export unmanaged and unknown computers

    Posted Jun 09, 2009 03:38 AM
    Hi Faith,

    You can't.  As this site i.e. https://fileshare.symantec.com is use for uploading any case logs or for symantec tools.

    Rgrds,
    SAM


  • 13.  RE: export unmanaged and unknown computers

    Posted Jun 09, 2009 04:11 AM
    well how can i download script in there?


  • 14.  RE: export unmanaged and unknown computers

    Posted Jun 09, 2009 08:45 AM
    Hi
     Check in the Download option tab in Connect Community on top

    https://www-secure.symantec.com/connect/downloads