HP Xw460c HP Insight Control Environment User Guide - Page 66

Generating a SQL queries list, Generating a CSV File Generator Report, Show SQL queries, Generate File

Page 66 highlights

Generating a SQL queries list 1. From the System Summary Report screen, select the server for which you want to generate a list. 2. Enter the appropriate dates in the Report on Data From and Report on Data To boxes to get the period for which you want to generate the list. 3. Click Show SQL queries. The SQL query appears in a separate browser window. Generating a CSV File Generator Report 1. When a separate browser window appears listing the selected servers, select the server for which you want to generate a report. 2. Enter the appropriate dates in the Extract Data From and Extract Data To boxes to get the period for which you want to generate the report. 3. Enter an appropriate file name with a .csv extension in the File Name box. 4. Click Generate File. The report appears in a separate browser window. Generating a SQL queries list 1. From the CSV File Generator screen, select the server for which you want to generate a list. 2. Enter the appropriate dates in the Extract Data From and Extract Data To boxes to get the period for which you want to generate the list. 3. Click Show SQL queries. The SQL query appears in a separate browser window. 66 Monitoring and controlling servers

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181

Generating a SQL queries list
1.
From the System Summary Report screen, select the server for which you want to generate a list.
2.
Enter the appropriate dates in the Report on Data From and Report on Data To boxes to get the period
for which you want to generate the list.
3.
Click
Show SQL queries
. The SQL query appears in a separate browser window.
Generating a CSV File Generator Report
1.
When a separate browser window appears listing the selected servers, select the server for which you
want to generate a report.
2.
Enter the appropriate dates in the Extract Data From and Extract Data To boxes to get the period for
which you want to generate the report.
3.
Enter an appropriate file name with a .csv extension in the File Name box.
4.
Click
Generate File
. The report appears in a separate browser window.
Generating a SQL queries list
1.
From the CSV File Generator screen, select the server for which you want to generate a list.
2.
Enter the appropriate dates in the Extract Data From and Extract Data To boxes to get the period for
which you want to generate the list.
3.
Click
Show SQL queries
. The SQL query appears in a separate browser window.
66
Monitoring and controlling servers