We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
1 day, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
PowerShell to crete HTML report
Posted on 2012-12-23
I am using the attached PowerShell scripts (XeAapp_Check.ps1, Ctx_functions.ps1) to export the XenApp 4.5 Zone details to HTML file as a report. On executing the script for the first time I am getting the desired result but unfortunately everytime I execute the script, the zone details gets appended to that report.
Here is my server details:
Farm Name: MyFarm
Server Name zone Name
========== ==========
XEN-1 192.168.1.0
XEN-2 TEST ZONE
Please assist me to get the correct result so that I can get the desired output by correctly modifying that script.
Ctx-Functions.txt
XenApp-Check.txt
XenApp-Check--Farm-Name--MyFarm-.mht
Here is my server details:
Farm Name: MyFarm
Server Name zone Name
========== ==========
XEN-1 192.168.1.0
XEN-2 TEST ZONE
Please assist me to get the correct result so that I can get the desired output by correctly modifying that script.
Ctx-Functions.txt
XenApp-Check.txt
XenApp-Check--Farm-Name--MyFarm-.mht
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
8
7
16 Comments
the problem is that its appended to the html result instead of generating fresh one?
can u describe expected result?
can u describe expected result?
Please find the attached expected result.
XenApp-Check--Farm-Name--MyFarm-.mht
XenApp-Check--Farm-Name--MyFarm-.mht
in XenApp-Check.txt script just before you call out-file to save as .htm (scroll all the way down the script), you wanna delete them if already exists:
if(Test-Path $FileXenApp_Check){
remove-item $FileXenApp_Check
}
if(Test-Path $FileXenApp_CheckBackup){
remove-item $FileXenApp_CheckBackup
}
$XenAppReport | out-file -encoding ASCII -filepath $FileXenApp_Check
$XenAppReport | out-file -encoding ASCII -filepath $FileXenApp_CheckBackup
echo "DONE"
i saw that you hard coded:
$Check_OutputEnteteZone = "TRUE"
when u generate the html, you iterate the zones:
If ($Check_OutputEnteteZone -eq "TRUE")
{
Foreach ($Zones in $Zones) {
so the if statement is redundant (cause its always true).
$Check_OutputEnteteZone = "TRUE"
when u generate the html, you iterate the zones:
If ($Check_OutputEnteteZone -eq "TRUE")
{
Foreach ($Zones in $Zones) {
so the if statement is redundant (cause its always true).
I've added the code you provided but still having the same result (please see the attached file). The report gets deleted but when recreated, the restult gets appended in the report.
I am not that much expert on PowerShell. Can you please guide me what should I do in case if I set $Check_OutputEnteteZone = "TRUE".
It would be very helpful of me if you could provide me the rectified code.
XenApp-Check--Farm-Name--MyFarm-.mht
I am not that much expert on PowerShell. Can you please guide me what should I do in case if I set $Check_OutputEnteteZone = "TRUE".
It would be very helpful of me if you could provide me the rectified code.
XenApp-Check--Farm-Name--MyFarm-.mht
Event I've deleted the "If ($Check_OutputEnteteZone -eq "TRUE")" condition and then executed the script, but getting same result.
#Farm Name
$XenAppReport = Get-CustomHTML "Farm Name : $Farm"
$XenAppReport += Get-CustomHeaderClose
#Write-CustomOut "..Adding Zones Details Info to the report"
Foreach ($Zones in $Zones) {
$OutputEnteteZone2 += @($Zones | Select @{N="Zone Name";E={if($Zones.ZoneName -eq $Null){"Error"}else{$Zones.ZoneName}}}, @{N="Zone Data Collector";E={if($Zones.DataCollector -eq $Null){"Error"}else{$Zones.DataCollector}}}) }
$XenAppReport += Get-CustomHeader ("Zone(s) Details : "+($Zones_Count))
$XenAppReport += Get-HTMLTable $OutputEnteteZone2
$XenAppReport += Get-CustomHeaderClose
$Date = Get-Date -Format "yyyyMMddHH"
$FileXenApp_Check = $Path + $FileName + ".htm"
$FileXenApp_CheckBackup = $PathBackup + $FileName + "_" + $date + ".htm"
if(Test-Path $FileXenApp_Check){
remove-item $FileXenApp_Check
}
if(Test-Path $FileXenApp_CheckBackup){
remove-item $FileXenApp_CheckBackup
}
$XenAppReport | out-file -encoding ASCII -filepath $FileXenApp_Check
$XenAppReport | out-file -encoding ASCII -filepath $FileXenApp_CheckBackup
echo "DONE"
What I have seen that, if I change the following variable name everytime then, I am getting the desired result.
$OutputEnteteZone
Also, I there is any way to delete the value of that variable then I think the result will come but I don't have any clue about how to do this.
$OutputEnteteZone
Also, I there is any way to delete the value of that variable then I think the result will come but I don't have any clue about how to do this.
change this:
to this:
--> remove if stetment and foreach stetment.
the if is redundant and the foreach already takes place when you call:
$OutputEnteteZone1 += @($Zones | ....
If ($Check_OutputEnteteZone -eq "TRUE")
{
Foreach ($Zones in $Zones) {
$OutputEnteteZone1 += @($Zones | Select @{N="Zone Name";E={if($Zones.ZoneName -eq $Null){"Error"}else{$Zones.ZoneName}}}, @{N="Zone Data Collector";E={if($Zones.DataCollector -eq $Null){"Error"}else{$Zones.DataCollector}}}) }
$XenAppReport += Get-CustomHeader ("Zone(s) Details : "+($Zones_Count))
$XenAppReport += Get-HTMLTable $OutputEnteteZone1
$XenAppReport += Get-CustomHeaderClose
}
to this:
$OutputEnteteZone1 += @($Zones | Select @{N="Zone Name";E={if($Zones.ZoneName -eq $Null){"Error"}else{$Zones.ZoneName}}}, @{N="Zone Data Collector";E={if($Zones.DataCollector -eq $Null){"Error"}else{$Zones.DataCollector}}})
$XenAppReport += Get-CustomHeader ("Zone(s) Details : "+($Zones_Count))
$XenAppReport += Get-HTMLTable $OutputEnteteZone1
$XenAppReport += Get-CustomHeaderClose
--> remove if stetment and foreach stetment.
the if is redundant and the foreach already takes place when you call:
$OutputEnteteZone1 += @($Zones | ....
Please find below the code as you instructed and the attached result. The result is getting appended everytime and the ouput is producing an error as $Zones.ZoneName value is producing NULL value.
$XenAppReport = Get-CustomHTML "Farm Name : $Farm"
$XenAppReport += Get-CustomHeaderClose
$OutputEnteteZone1 += @($Zones | Select @{N="Zone Name";E={if($Zones.ZoneName -eq $Null){"Error"}else{$Zones.ZoneName}}}, @{N="Zone Data Collector";E={if($Zones.DataCollector -eq $Null){"Error"}else{$Zones.DataCollector}}})
$XenAppReport += Get-CustomHeader ("Zone(s) Details : "+($Zones_Count))
$XenAppReport += Get-HTMLTable $OutputEnteteZone1
$XenAppReport += Get-CustomHeaderClose
$Date = Get-Date -Format "yyyyMMddHH"
$FileXenApp_Check = $Path + $FileName + ".htm"
$FileXenApp_CheckBackup = $PathBackup + $FileName + "_" + $date + ".htm"
if(Test-Path $FileXenApp_Check){
remove-item $FileXenApp_Check
}
if(Test-Path $FileXenApp_CheckBackup){
remove-item $FileXenApp_CheckBackup
}
$XenAppReport | out-file -encoding ASCII -filepath $FileXenApp_Check
$XenAppReport | out-file -encoding ASCII -filepath $FileXenApp_CheckBackup
echo "DONE"
the problem is not appending the file but the $zones creation.
there's a function called GET-XAZone i assume which returns aggregated $Zones.
i couldn't;t find source of this function in the files you've attached.
please check $Zones.Count when code is back from GET-XAZone.
i guess that from second run you get aggregated result.
but again do not have the source of GET-XAZone.
there's a function called GET-XAZone i assume which returns aggregated $Zones.
i couldn't;t find source of this function in the files you've attached.
please check $Zones.Count when code is back from GET-XAZone.
i guess that from second run you get aggregated result.
but again do not have the source of GET-XAZone.
Did you try setting $OutputEnteteZone1 to $null
$OutputEnteteZone1 = $null
If ($Check_OutputEnteteZone -eq "TRUE")
{
Foreach ($Zones in $Zones) {
$OutputEnteteZone1 += @($Zones | Select @{N="Zone Name";E={if($Zones.ZoneName -eq $Null){"Error"}else{$Zones.ZoneName}}}, @{N="Zone Data Collector";E={if($Zones.DataCollector -eq $Null){"Error"}else{$Zones.DataCollector}}}) }
$XenAppReport += Get-CustomHeader ("Zone(s) Details : "+($Zones_Count))
$XenAppReport += Get-HTMLTable $OutputEnteteZone1
$XenAppReport += Get-CustomHeaderClose
}
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| PowerCLI Command For Guest VM Boot Time | 1 | 37 | |
| convert from shell script to powershell | 15 | 46 | |
| Office 365 License type - report for a list of users | 7 | 33 | |
| Script PowerShell - List KB installed | 15 | 27 |
A brief introduction to what I consider to be the best editor for PowerShell.
Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed.
Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video.
We have explained the difference between…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses
Course of the Month1 day, 19 hours left to enroll
710 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.