cancel
Showing results for 
Search instead for 
Did you mean: 

opscenter views on polciy type

nbritton
Level 4

Has anyone found a way to create a view that would be based on the policy type.  Such as a view that contain all sql policies or all exchange policies?

5 REPLIES 5

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Go to Views

Click Add View

Enter the name of the view

Select Client / Policy (depending how you'd like to group objects in the view)

Save the view

Select the view and click manage nodes and objects

You'll see "No data found"

Click Object not in selected view

select the client / policy and select add to node (what ever your had selected will disappear from the view)

Click finish

Your view will now be available in the monitor and report sections.

 

 

 

nbritton
Level 4

I was looking to do it on type of policy.  I was going to adjust my naming standard , but there is no dynamic options it would appear.  Has anyone found a way to dynamicly add polcies to a view.

 

Lets say you had sql1 sql2 sql3 as policy names at the time you created the view, but later you create sql4, it would be nice if the view could be sql* including all polcies that start with sql, but i have yet to find that option.

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Sorry I misunderstood. Dont think you'll able to do that unless rhe code is modified.

tom_sprouse
Level 6
Employee Accredited Certified

nbritton, 

If you cannot set a filter for policy type on the report you have created, you may look at custom sql options...

You maybe able to pick your policy type value from the lookup_policytype table.

Example: 

SELECT * FROM lookup_policytype

id             name
----------------------------
0              Standard 
4              Oracle 
6              Informix-On-BAR 
8              MS-SharePoint 
13          MS-Windows 
15          MS-SQL-Server 
16          MS-Exchange-Server 
19          NDMP 
20          FlashBackup 
35          NBU-Catalog 
40          VMware 
41          Hyper-V

 

Appendex D in the opscenter admin guide will get you there with some scripting .

 

here is what i have so far:

 

## BPPLIST AUDIT INFO

#Vars
#region Vars
$admincmd="C:\Program Files\Veritas\NetBackup\bin\admincmd"
$opscentercmd="C:\Program Files\Symantec\OpsCenter\server\bin"
$masters=("server1", "server2")
$bus=("_e","_s","_i","_r","_c")
$bppllistOut = @()
$outputdir="E:\Data\Scripts\output\view_create"
$date = (get-date).tostring("yyyyMMdd")
#endregion


#HASH Lookup Tables
#region HASH's
$MasterEnvHash = @{"master1" = "site1"; "master2" = "site2"}
$BuHash = @{"_1" = "bu1"; "_2" = "bu2"}
$YesNoHash = @{"0" = "Yes"; "1" = "No"}
$NoYesHash = @{"0" = "No"; "1" = "Yes"}
$MachineTypeHash = @{"0" = "No virtual machine"; "1" = "VMware"; "2" = "Hyper-V"; "3" = "VxVI"}
$PolicyTypeHash = @{"0" = "Standard"; "1" = "Proxy"; "4" = "Oracle"; "6" = "Informix-On-BAR"; "7" = "Sybase";
"8" = "MS-SharePoint portal server"; "11" = "DataTools-SQL-BackTrack"; "13" = "MS-Windows"; "15" = "MS-SQL-Server";
"16" = "MS-Exchange-Server"; "17" = "SAP"; "18" = "DB2"; "19" = "NDMP"; "20" = "FlashBackup"; "21" = "Splitmirror";
"25" = "Lotus Notes"; "29" = "FlashBackup-Windows"; "35" = "NBU-Catalog"; "36" = "Generic"; "38" = "PureDisk export";
"39" = "Enterprise_Vault"; "40" = "VMware"; "41" = "Hyper-V"}

#endregion

#region BPPLLIST

#Gather Info
$bppllistInfo = @()
Foreach ($master in $masters) {
$policylist = & "$admincmd\bppllist" -M $master
#Collect POlicy Info
Foreach ($policy in $policylist){
$grab = & "$admincmd\bppllist" $policy -M $master

#INFO Fields
$info = $grab|sls "INFO ".ToString()
$info = $info -split(" ")
$infoPolicyType = $info[1]
$infoPolicyActive = $info[11]
$infoLifeCyleInuse = $info[30]
$infoMachineTYpe = $info[33]

#Client Fields
$client = $grab |sls "CLIENT "
foreach ($line in $client){
$line.ToString()
$line = $line -split(" ")
$ClientName = $line[1]
#Populate Array
$Properties = @{Name=$ClientName; Master=$master; Policy=$policy; PolicyType=$PolicyTypeHash.$infoPolicyType}
$Newobject = New-Object PSObject -Property $Properties
$bppllistInfo += $Newobject
}


}
}


#endregion

#region bpimagelist
#bpimagelist works
$BpImageListInfo = @()
$bpimagePolicyTypes = ("VMware", "MS-SQL-Server")
Foreach ($master in $masters) {
write-host "Processing started for master $master"
foreach ($BpImagePt in $bpimagepolicytypes){
write-host "Processing started for PolicyType $BpImagePt" $BpImageListInfo.count
$bpimagelist = & "$admincmd\bpimagelist" -l -M $master -hoursago 168 -pt $BpImagePt| sls IMAGE
Foreach ($image in $bpimagelist){
$image = $image.tostring()
$image = $image -split(" ")
$bpimageClient = $image[1]
$bpimagePolicyName = $image[6]
$bpimagePolicyType = $image[7]
#Populate Array with data
$Properties = @{Name=$bpimageClient; Master=$master; Policy=$bpimagePolicyName; PolicyType=$PolicyTypeHash.$bpimagePolicyType}
$Newobject = New-Object PSObject -Property $Properties
$BpImageListInfo += $Newobject
}
}
}
$BpImageListInfo = $BpImageListInfo| Sort-Object -Property Name -Unique
#endregion

#region Combine arrays for final work
$policyInfo = @()
$policyInfo = $bppllistInfo
Foreach ($image in $BpImageListInfo){

$bpimageClient = $image.Name
$bpimageMaster = $image.Master
$bpimagePolicyName = $image.Policy
$bpPolicyType = $image.PolicyType

#Populate Array with data
$Properties = @{Name=$bpimageClient; Master=$bpimagemaster; Policy=$bpimagePolicyName; PolicyType=$bpPolicyType}
$Newobject = New-Object PSObject -Property $Properties
$policyInfo += $Newobject

}
#endregion


#region Build BU Import File
foreach ($bu in $bus){

Write-Host "starting work for $bu"

$BuPolicyInfo = $PolicyInfo|Where-Object {$_.Policy -like "?????${bu}?_*"}
Write-Host "Finishing work for $bu with count of " $buPolicyInfo.Count
foreach ($line in $BuPolicyInfo){
$buClient = $line.Name
$buMaster = $line.Master
$buPolicyName = $line.Policy
$buPolicyType = $line.PolicyType
$buname = $BuHash.$bu
$buMaster = $MasterEnvHash.$buMaster
echo "client,$buname-all,$bumaster,$buPolicyType,$buClient"|Out-File -FilePath $outputdir\view_bu_all.csv -encoding ASCII -append
}

}
$BuPolicyInfo | Format-Table
#endregion

#region Import View files
#& "$opscentercmd\view_exportimport.bat" -i -f $outputdir\view_bu_all.csv --type csv --usr someuser --pass something --domain somedomain --domaintype nt -l $outputdir\importlog\view_bu_all_import.txt -v 8
#endregion

 

 

Problems i have with this so far,

 

* Some clients are not found on import -- case open

* comandline import still wants user values -- work in progress