This script is modified from web to perform auditing of local server groups 
and their members.  Since I have to do this on a large number of servers I 
would like the results written to a Access Database instead of on large text 
file.  Since I am fairly new to powershell and scripting I dont know how to 
do this.  Any assistance would be greatly appreciated.


########################
#Functions
########################
$arrExclude = "NT AUTHORITY\LocalService",
            "NT AUTHORITY\Local Service",
            "NT AUTHORITY\NETWORK SERVICE",
            "NT AUTHORITY\NetworkService",
            "LocalSystem",
            ".\ASPNET" 

function checkExclusions([string]$strval)
    {
    foreach ($val in $arrExclude)
        {if ($val.ToLower() -eq $strval){return $true}  }
    return $false
    }

function Ping (  [string] $strComputer )
{
  $timeout=120;
  trap { continue; }

  $ping = new-object System.Net.NetworkInformation.Ping
  $reply = new-object System.Net.NetworkInformation.PingReply

  $reply = $ping.Send($strComputer, $timeout);
  if( $reply.Status -eq "Success"  )
  {
     return $true;
  }
  return $false;
}

########################
#Script
########################
$pathFolder = "D:\ServerBiYearlyScan\CRB\Group"
$computersList = get-content "$pathFolder\CRBServer001.txt"
$ArrayUser = @()
$ArrayGroup = @()
$ArrayKey = @()
$ArrayService = @()
$ArrayShare = @()
$ArrayAccess = @() 

foreach($computer in $computersList)
{

#################################################################################################
$retPing = Ping $computer
if($retPing -eq $true)
    {
    #Disabling the error on the screen
    $errorActionPreference="SilentlyContinue"
    $testAccss = get-wmiobject Win32_OperatingSystem -computername $computer 
-ErrorVariable ERR
        If($ERR)
            {$Access = $false}
        else{$Access = $true}
    }
else{$Access = $false}

if($Access -eq $false)
    {
    #Srv not ping or denied
    $obj=New-Object PSObject
    $obj | Add-Member Noteproperty -Name "ServerName" -Value 
(($computer).trim()).ToUpper()
    $obj | Add-Member Noteproperty -Name "PING" -Value $retPing
    $obj | Add-Member Noteproperty -Name "ACCESS" -Value $Access
    $ArrayAccess += $obj
    }
else{
    #Working on it

#################################################################################################

$namespace = "root\CIMV2"
$results = Get-WmiObject -class Win32_Group -computername $computer 
-namespace $namespace -filter "localaccount=true"
foreach($result in $results)
    {
   
    $GroupName = $result.name
    $group =[ADSI]"WinNT://$computer/$GroupName"
    $members = @($group.psbase.Invoke("Members"))
    $list = $members | foreach {$_.GetType().InvokeMember("Name", 
'GetProperty', $null, $_, $null)}
    if($list -ne $null)
        {
        foreach($member in $list)
            {
           
            $obj=New-Object PSObject
            $obj | Add-Member Noteproperty -Name "ServerName" -Value 
(($computer).trim()).ToUpper()
            $obj | Add-Member Noteproperty -Name "GroupName" -Value 
(($result.name).trim()).ToUpper()
            $obj | Add-Member Noteproperty -Name "Member" -Value 
(($member).trim()).ToUpper()
            $ArrayGroup += $obj
            }
        }
    else
        {
        $obj=New-Object PSObject
        $obj | Add-Member Noteproperty -Name "ServerName" -Value 
(($computer).trim()).ToUpper()
        $obj | Add-Member Noteproperty -Name "GroupName" -Value 
(($result.name).trim()).ToUpper()
        $obj | Add-Member Noteproperty -Name "Member" -Value ""
        $ArrayGroup += $obj
        }

    }

#################################################################################################

    }

}

$ArrayGroup | select ServerName, GroupName, Member | out-file 
"$pathFolder\CRBLocalGroups001.txt"


-- 
Tim Dixon

Search is your friend.  As the PowerShell community continues to grow, 
chances are that you'll find something already written to help.

I searching for "powershell access database" with bing.com, and one of the 
first hits:
http://technet.microsoft.com/en-us/magazine/2009.05.scriptingguys.aspx?pr=blog

Take a read at that first.  Come back if you still have any questions.

Marco

"Tim Dixon" <TimDixon@discussions.microsoft.com> wrote in message 
news:787EE63D-E6C4-4B51-BB0C-9C4440BC4369@microsoft.com...
> This script is modified from web to perform auditing of local server 
> groups
> and their members.  Since I have to do this on a large number of servers I
> would like the results written to a Access Database instead of on large 
> text
> file.  Since I am fairly new to powershell and scripting I dont know how 
> to
> do this.  Any assistance would be greatly appreciated.