Выгрузка списка общих ресурсов в Excel и txt
Excel:
$strPath="c:\fso\mySheet.xls"
$objExcel=New-Object -ComObject Excel.Application
$objExcel.Visible=-1
$WorkBook=$objExcel.Workbooks.Add()
$sheet=$workbook.worksheets.item(1)
$x=2
$strComputer = "."
$objWMIService = Get-WmiObject win32_Share
$sheet.Cells.item(1,1)=("Name of Share")
$sheet.Cells.item(1,2)=("Description of Share")
$sheet.Cells.item(1,3)=("Type of Share")
ForEach ($objShare in $objWMIService)
{
$sheet.Cells.item($x, 1)=($objShare.Name)
$sheet.Cells.item($x, 2)=($objShare.Description)
$sheet.Cells.item($x, 3)=($objShare.Type)
If($objShare.type -ne 0)
{
$sheet.Cells.item($x,3).font.colorIndex=3 # 32 is blue 16 silver/gray 8 is Aqua, 4 is green, 3 is red
$sheet.Cells.item($x,3).font.bold=$true
}
$x++
}
$range = $sheet.usedRange
$range.EntireColumn.AutoFit()
IF(Test-Path $strPath)
{
Remove-Item $strPath
$objExcel.ActiveWorkbook.SaveAs($strPath)
}
ELSE
{
$objExcel.ActiveWorkbook.SaveAs($strPath)
}
Txt:
$class = "win32_share" $filePath = "c:\fso\shares.txt" Get-WmiObject -class $class | Format-Table -property name -hidetableheader | Out-File -FilePath $filePath -encoding ASCII
Голосов пока нет

Оставить комментарий