Novell ZENworks Endpoint Security Management 3.5 Manual de usuario descargar pdf (Pagina 229)

ZENworks® ESM 3.5 Administrator’s Manual 229

Tracing Novell Database Installations

The Novell Database architecture uses stored procedures extensively throughout. It is important

to be able to identify these interactions processes for debugging the system.

Figure 112 : Database Tracing

The highlighted row represents a client check-in to the Distribution Service. The statement,

decomposed shows the following:

Return Variable declaration: declare @P1 int

Return Variable assignment: set @P1=0

Call to Stored Procedure: exec CHECKIN_SP

User Credential: '{CA6AAD8A-7DBF-48DF-A682-6EE535573B77}',

Policy Id: '2e58dafe-6ce1-44f5-9b40-557354e814f8',

Location Id: '{64A2C1F3-E8FE-4E42-B77B-4C21A4C305BC}',

Result Code: @P1 output

If you are having difficulty getting the client to download a published policy, performing a trace

and capturing the Check In call will aide in identifying whether or not a user has a policy

assigned. In this example, using the captured SQL state above, open SQL Query Analyzer from

the Tools Menu and connect to the Novell Distribution Service database instance. Paste the text

captured from the trace into the window and run the query (F5, Ctrl-E or press the Play button.)

If the user has items assigned to him/her through publishing, you will receive rows. In every case,

you will receive a result code as demonstrated below:

1 2 ... 224 225 226 227 228 229 230 231 232 233 234 ... 244 245

Sin comentarios

Novell ZENworks Endpoint Security Management 3.5 Manual de usuario Pagina 229