Hi Everyone,

Here you will find a solution to a problem that I have tried to solve this week, and that could be useful in every Qlik infrastructure.

For anyone who has tried to get a global view of the Qlik services states, here is the solution I found.

@marcus_sommer I thought this might interest you

1.

• Create a Powershell script (.Ps1) that loop on a list of servers that you define.
• Get the state of every Qlik service.
• Verify if that state if Running or not.
• Prepare the csv file structure (Date, Server, Service, State) and export it.

       * with "append" option to be able to schedule the script to run at a certain frequency on a day and don't lose the lines created each time.

2.

• Create a .BAT file that calls Powershell.exe to launch the (Ps1) file.
• Schedule it using the Windows Task scheduler or the QMC.

Below the Powershell Script:

#Define a list of servers
$servers = @("xxx-xxx-xxx","xxx-xxx-xxx","xxx-xxx-xxx"...)

#Loop on the servers defined above
foreach ($server in $servers) {

    #Get the actual date
    $getDate = Get-Date

    #Get the state of all Qlik services
    $statusQlikviewDirectoryServiceConnector = (get-service "QlikviewDirectoryServiceConnector" -ComputerName $server).Status
    $statusQlikViewDistributionService       = (get-service "QlikViewDistributionService"       -ComputerName $server).Status
    $statusQlikviewManagementService         = (get-service "QlikviewManagementService"         -ComputerName $server).Status
    $statusQlikviewServer                    = (get-service "QlikviewServer"                    -ComputerName $server).Status
    $statusQlikViewSettingsService           = (get-service "QlikViewSettingsService"           -ComputerName $server).Status

    #Verify if the QlikviewDirectoryServiceConnector is Running
    if ($statusQlikviewDirectoryServiceConnector -eq "Running") {

        "$getDate $servers  QlikviewDirectoryServiceConnector is up"

        $vExportQlikviewDirectoryServiceConnector = @{
        Date=$getDate
        Server=$servers
        Service='QlikviewDirectoryServiceConnector'
        Status=$statusQlikviewDirectoryServiceConnector
         }
        $results = New-Object psobject -Property $vExportQlikviewDirectoryServiceConnector
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    } 
    
    else {

        "$getDate $servers QlikviewDirectoryServiceConnector is down"

        $vExportQlikviewDirectoryServiceConnector = @{
        Date=$getDate
        Server=$servers
        Service='QlikviewDirectoryServiceConnector'
        Status=$statusQlikviewDirectoryServiceConnector
         }
        $results = New-Object psobject -Property $vExportQlikviewDirectoryServiceConnector
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    }


    #Verify if the Service QlikViewDistributionService is Running
    if ($statusQlikViewDistributionService -eq "Running") {

        "$getDate $servers QlikViewDistributionService is up"

        $vExportQlikViewDistributionService = @{
        Date=$getDate
        Server=$servers
        Service='QlikViewDistributionService'
        Status=$statusQlikViewDistributionService
         }
        $results = New-Object psobject -Property $vExportQlikViewDistributionService
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    } 
    
    else {

        "$getDate $servers QlikViewDistributionService is down"

        $vExportQlikViewDistributionService = @{
        Date=$getDate
        Server=$servers
        Service='QlikViewDistributionService'
        Status=$statusQlikViewDistributionService
         }
        $results = New-Object psobject -Property $vExportQlikViewDistributionService
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    }


    #Verify if the service QlikviewManagementService is running
    if ($statusQlikviewManagementService -eq "Running") {

        "$getDate $servers QlikviewManagementService is up"

        $vExportQlikviewManagementService = @{
        Date=$getDate
        Server=$servers
        Service='QlikviewManagementService'
        Status=$statusQlikviewManagementService
         }
        $results = New-Object psobject -Property $vExportQlikviewManagementService
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    } 
    
    else {

        "$getDate $servers QlikviewManagementService is down"

        $vExportQlikviewManagementService = @{
        Date=$getDate
        Server=$servers
        Service='QlikviewManagementService'
        Status=$statusQlikviewManagementService
         }
        $results = New-Object psobject -Property $vExportQlikviewManagementService
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    }


    #Verify if the service QlikviewServer is Running
    if ($statusQlikviewServer -eq "Running") {

        "$getDate $servers QlikviewServer is up"

        $vExportQlikviewServer = @{
        Date=$getDate
        Server=$servers
        Service='QlikviewServer'
        Status=$statusQlikviewServer
         }
        $results = New-Object psobject -Property $vExportQlikviewServer
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    } 
    
    else {

        "$getDate $servers QlikviewServer is down"

        $vExportQlikviewServer = @{
        Date=$getDate
        Server=$servers
        Service='QlikviewServer'
        Status=$statusQlikviewServer
         }
        $results = New-Object psobject -Property $vExportQlikviewServer
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    }


    #Verify if the service QlikViewSettingsService is running
    if ($statusQlikViewSettingsService -eq "Running") {

        "$getDate $servers QlikViewSettingsService is up"

        $vExportQlikViewSettingsService = @{
        Date=$getDate
        Server=$servers
        Service='QlikViewSettingsService'
        Status=$statusQlikViewSettingsService
         }
        $results = New-Object psobject -Property $vExportQlikViewSettingsService
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    } 
    
    else {

        "$getDate $servers QlikViewSettingsService is down"

        $vExportQlikViewSettingsService = @{
        Date=$getDate
        Server=$servers
        Service='QlikViewSettingsService'
        Status=$statusQlikViewSettingsService
         }
        $results = New-Object psobject -Property $vExportQlikViewSettingsService
        $results | Export-Csv -path C:\Temp\Powershell\Eventlogs.csv -NoTypeInformation -Append

    }

}

Here is the output of the file export using the script above:

"Date","Status","Server","Service"
"06/03/2019 17:22:34","Running","vw-d-rxx-05","QlikviewDirectoryServiceConnector"
"06/03/2019 17:22:34","Running","vw-d-rxx-05","QlikViewDistributionService"
"06/03/2019 17:22:34","Running","vw-d-rxx-05","QlikviewManagementService"
"06/03/2019 17:22:34","Running","vw-d-rxx-05","QlikviewServer"
"06/03/2019 17:22:34","Running","vw-d-rxx-05","QlikViewSettingsService"

If you need more details on how you run all this and get the schedueling done, don't hesitate to leave a comment or send me a direct message.

Have a great day !

Youssef