Table pnp_operation
Description
Allows you to store operations that can potentially last a long time (print queue installation for example), in order to follow the progress as you go along (by updating and consulting this table), as well as to keep a history.
Schema
|
Field |
Type |
Required |
Primary key |
Description |
|
opeID |
uniqueidentifier |
* |
* |
Guid identifier |
|
opeSTATUSID |
int |
|
|
Operation Status : 17 = Waiting 18 = Running 19 = Succès 20 = Failure 21 = Cancelled |
|
opeSTEPID |
int |
* |
|
Operation steps: Between 1 and 4 1 = Pre-processing 2 = Processing 3 = Post processing 4 = End |
|
opeTYPEID |
int |
* |
|
Type of operation: 1 = Print queue creation 2 = Multiple queue creation 3 = Modify queue 4 = Delete queue 5 = Test print queue 6 = Definitive deletion of a File 7 = Change of status of a queue 8 = Resuming a queue 9 = Driver installation 10 = Audit 11 = Audit of the solution 12 = Server removal 13 = Database modification 14 = Switch printer to multi OS 15 = Switch printer to single OS 16 = Update of events 22 = Table purge 24 = General settings 25 = Add a print server 26 = Modification of a server 27 = Adding a server type 28 = Modifying a server type 29 = Delete a server type 30 = Configuration of templates and drivers 31 = Delete a server 32 = Printer transfer 33 = Delete printers Moved 34 = Inject a printer into the Repository 36 = Switch to maintenance mode 37 = Switch to normal mode 39 = Modification of a printer In the repository 41 = Restoring a printer 47 = Recovering information From the queue in Watchdoc 48 = Purge printers in status Deleted 50 = Recovery of installed drivers On the server 51 = Creation of server backup 52 = Restore server from A backup 54 = Delete a printer On a server 59 = Mass transfer of a printer 60 = Restoring the server and the Repository |
|
opePNPQUEUEID |
uniqueidentifier |
|
|
If the operation concerns a line, then the guideline which identifies it is referred to Here, NULL otherwise |
|
opeDRIVERID |
int |
|
|
If the operation concerns a driver, then its identifier is referenced, NULL otherwise |
|
opeSERVERFQDN |
nvarchar(max) |
|
|
If the operation is performed on a server,FQDN of the server, NULL otherwise |
|
opeSERVERID |
nvarchar(max) |
|
|
If the operation is performed on a server,Server identifier, NULL otherwise |
|
opeBEGINDATE |
datetime |
* |
|
Start date of the operation |
|
opeENDDATE |
datetime |
|
|
End date of the operation whenTerminated, NULL otherwise |
|
opeUSER |
nvarchar(max) |
|
|
User who launched the operation, 'PnP' when the operation wasGenerated via our programs |