Hi Clifford,
Here is the script. You need to create batch file which will be scheduled to run on your preferred time.
BackupInventory.Bat
cd/
cd windows\system32\WindowsPowerShell\v1.0
powershell.exe -command "& 'C:\PATHOFTHEFOLDER\Backup_Inventory.ps1' "
exit
--------------------------
Here is the Backup_Inventory.ps1 (powershell script). You can change the color in background etc and can do bit more formatting if you want to make it more fancy.
# Import the Backup Exec 2012 PowerShell Module
Import-Module BEMCLI
# Inventory the backup tapes in the tape drives:
Get-BETapeDriveDevice |
Submit-BEInventoryJob |
select Name, JobType, Schedule, Storage |
ft –auto
Start-Sleep -s 60
$a = "<style>"
$a = $a + "BODY{background-color:peachpuff;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:thistle}"
$a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:PaleGoldenrod}"
$a = $a + "</style>"
# Once the inventory completes, retrieve the name of the backup tape in each tape drive:
Get-BETapeDriveDevice | ConvertTo-HTML -head $a -body "<H2> Symantec Backup Exec Inventory Report</H2>" -Name, Media, Status, Device > "C:\PATHToCreateReport\BackupInventory\report.html"
Send-MailMessage -To "Your Email Address" -From "From Email Address" -Subject "Backup Inventory Report" -SmtpServer "smtp server name or IPaddress" -Body "Please find the attached Inventory Report" -Attachments "C:\PathToCreateReport\BackupInventory\report.html"
Hope this helps. I will be still interested if Symantec puts this job log back in Inventory.
