PC Professionell 2007 April

home *** CD-ROM | disk | FTP | other *** search

/ PC Professionell 2007 April / PCpro_2007_04.ISO / files / dsl / ManageEngineWiFiManager.exe / Disk1 / data1.cab / SourceFiles / WiFiManager.exe / conf / DatabaseAliases.conf < prev next >

Wrap

Text File | 2007-01-17 | 19.6 KB | 991 lines

//$Id: DatabaseAliases.conf,v 1.61 2006/11/07 02:02:19 mohan Exp $ # This file is to specify the aliases used in the particular databases for the # column names . The column names of the various tables by default are the same # as the field name in the respective object . But in databases which may treat # some of these columnNames as reserved words or where there does not exist # support for case sensitivity in column Names it becomes necessary to replace them # with other words . This file helps specify those changes if any . It is to be noted # that specifying in this file should be accompanied by the appropriate changes in # the DatabaseSchema.conf file too . To illustrate this point see the two example # files DatabaseAliases.conf.example1 and DatabaseSchema.conf.example1 . # You will notice that both these conf files are in agreement . That is when # a column Name is given an alias it is taken care to specify the alias in the # schema file while creating the database . # The syntax of the file is as follows # column name( as orginally designed alias (the name which is assigned # Note that in this file the quotes should not be specified but in DatabaseSchema.conf # it is insisted that all columnNames be specified inside quotes # For ease of use all the column Names which are used are given with details of # which all tables they appear in .Note that no aliases have been assigned . # Unless it is required to change to suit your database please do not assign # any aliases . # Please be very careful in editing this file as a wrong alias assigned here # without appropriate changes in the Schema file will lead to a host of errors # In Tables ObjectTypes , ALERTUSERPROPS ,MAPUSERPROPS ,TOPOUSERPROPS and POLLUSERPROPS objkey OBJKEY # In Tables ALERTUSERPROPS ,MAPUSERPROPS ,TOPOUSERPROPS and POLLUSERPROPS propName PROPNAME propVal PROPVAL # In Tables ObjectTypes, Reports and ManagedObject classname CLASSNAME # In Tables ManagedObject , TopoObject, Node, Network, IpAddress, SnmpInterface # SnmpNode, GroupTable, MapSymbol, MapGroup, MapLink, PolledData, PollingObjects,PollingAttributes,ThresholdObjects, DataCollectionAttributes and any other table # that is created to store a user written sub-class of ManagedObject name NAME # ownerName is also in tables Event, Alert (in addition to the above tables). ownerName OWNERNAME # that is created to store a user written sub-class of ManagedObject displayName DISPLAYNAME # In the Tables ManagedObject managed MANAGED # In the Table ManagedObject type TYPE failureThreshold FAILURETHRESHOLD failureCount FAILURECOUNT pollInterval POLLINTERVAL statusChangeTime STATUSCHANGETIME statusUpdateTime STATUSUPDATETIME tester TESTER uClass UCLASS statusPollEnabled STATUSPOLLENABLED isContainer ISCONTAINER isGroup ISGROUP customDisplayName CUSTOMDISPLAYNAME # In the Tables ManagedObject and MapLink status STATUS # In the Tables ManagedObject, MapSymbol, MapGroup, MapLink, Alert, Event # and PolledData webNMS WEBNMS groupName GROUPNAME parentName PARENTNAME subviewName SUBVIEWNAME parentKey PARENTKEY # In the table TopoObject ipAddress IPADDRESS netmask NETMASK writeCommunity WRITECOMMUNITY snmpport SNMPPORT baseMibs BASEMIBS isDHCP ISDHCP version VERSION userName USERNAME contextName CONTEXTNAME isSNMP ISSNMP isNode ISNODE isNetwork ISNETWORK isInterface ISINTERFACE # In the Tables TopoObject and PolledData community COMMUNITY # In the Table Node isRouter ISROUTER # In the Table Network discoveryStatus DISCOVERYSTATUS parentNetwork PARENTNETWORK parentNetmask PARENTNETMASK # In the Tables Network discover DISCOVER # In the Table IpAddress parentNode PARENTNODE parentNet PARENTNET # In the Table SnmpNode sysDescr SYSDESCR sysName SYSNAME # In the Tables SnmpNode and SnmpInterface hostNetmask HOSTNETMASK sysOID SYSOID # In the Table SnmpInterface ifIndex IFINDEX physMedia PHYSMEDIA physAddr PHYSADDR ifSpeed IFSPEED ifDescr IFDESCR # In the Table GroupTable memberName MEMBERNAME memberOwnerName MEMBEROWNERNAME # In the Tables ANNOTATION and Alert who WHO modTime MODTIME notes NOTES # In the Tables Alert ,PolledData and Event id ID # In the Tables Alert and Event entity ENTITY severity SEVERITY ALARMCODE ALARMCODE # In the Tables Alert,MapLink, and Event source SOURCE # In the Tables Alert ,Event and ThresholdEvents category CATEGORY # In the Tables Alert and PolledData previousSeverity PREVIOUSSEVERITY message MMESSAGE # In the Table Alert createTime CREATETIME stage STAGE priority PRIORITY # In the Tables MapGroup, MapSymbol and MapLink label LABEL menuName MENUNAME # In the Tables MapGroup, MapSymbol and MapLink mapName MAPNAME x X y Y anchored ANCHORED # In the Tables MapGroup, MapSymbol and MapLink objName OBJNAME renderingCode RENDERINGCODE # In the Table MapGroup, MapSymbol iconName ICONNAME width WIDTH height HEIGHT # In the Table MapSymbol,MapGroup objType OBJTYPE # In the Table MapLink dest DEST thickness THICKNESS linkType LINKTYPE nx NX ny NY # In the Tables Event and StatsData, STATSDATA_HOURLY, STATSDATA_DAILY time TTIME # In the Table Event text TEXT domain DDOMAIN network NETWORK node NODE helpURL HELPURL # In the Table PolledData agent AGENT period PERIOD active ACTIVE oid OID logDirectly LOGDIRECTLY logFile LOGFILE save SSAVE threshold THRESHOLD isMultiplePolledData ISMULTIPLEPOLLEDDATA numericType NUMERICTYPE saveAbsolutes SAVEABSOLUTES timeAvg TIMEAVG port PORT lastCounterValue LASTCOUNTERVALUE lastTimeValue LASTTIMEVALUE timeVal TIMEVAL policyName POLICYNAME dnsName DNSNAME statsDataTableName STATSDATATABLENAME suffix SUFFIX thresholdList THRESHOLDLIST pollerName POLLERNAME failureCount FAILURECOUNT failureThreshold FAILURETHRESHOLD parentObj PARENTOBJ protocol PROTOCOL savePollCount SAVEPOLLCOUNT currentSaveCount CURRENTSAVECOUNT saveOnThreshold SAVEONTHRESHOLD snmpVersion SNMPVERSION userName USERNAME contextName CONTEXTNAME # In the Table MapContainer currentTopology CURRENTTOPOLOGY topology TOPOLOGY containment CONTAINMENT # In the Table MapDB parentMapKey PARENT mapListener MAPLISTENER mapSymbolRenderer MAPSYMBOLRENDERER mapLinkRenderer MAPLINKRENDERER helpDoc HELPDOC treeIconFileName TREEICONFILENAME autoPlacement AUTOPLACEMENT imageName IMAGENAME # In the table PollingAttributes type TYPE condition CONDITION property PROPERTY value VALUE # In the table ThresholdObjects kind KIND severity SEVERITY triggerSeverity TRIGGERSEVERITY resetSeverity RESETSEVERITY thresholdType THRESHOLDTYPE category CATEGORY thresholdValue THRESHOLDVALUE rearmValue REARMVALUE message MMESSAGE clrMessage CLEARMESSAGE sendClear SENDCLEAR allowed ALLOWED disallowed DISALLOWED oid OID oidType OIDTYPE # In the table Providers providerName PROVIDERNAME value VALUE # In the Tables TrapFilter enterpriseOID ENTERPRISEOID gt GT st ST trapOID TRAPOID state STATE # In the Tables TrapParser ,EventParser ,EventAlertFilter, DateCollectionAttributes propKey PROPKEY propValue PROPVALUE # In the Tables EventAlertFilter filterName FILTERNAME actionName ACTIONNAME #In the table Reports daily DAILY weekly WEEKLY monthDays MONTHDAYS weekDays WEEKDAYS hour HOUR timeVal TIMEVAL # In the Table PolicyObject groupName GROUPNAME status STATUS policyObjectCustomizer POLICYOBJECTCUSTOMIZER helpURL HELPURL #In Table SwitchObject rootPort ROOTPORT rootCost ROOTCOST numPorts NUMPORTS #In Table PortObject portAdminStatus PORTADMINSTATUS PortMacAddress PORTMACADDRESS IsForward ISFORWARD portIfIndex PORTIFINDEX portIfDescr PORTIFDESCR portState PORTSTATE portIfSpeed PORTIFSPEED #In Table Printer deviceStatus DEVICESTATUS printerStatus PRINTERSTATUS printerDetectedErrStatus PRINTERDETECTEDERRSTATUS consoleDispBufferText CONSOLEDISPBUFFERTEXT #In Table AgentDefValObject name NAME value VALUE #In Table PolicyScheduleTime timeKey TIMEKEY #In Table TaskAudit executionID EXECUTIONID taskName TASKNAME deviceList DEVICELIST datasource DATASOURCE executedTime EXECUTEDTIME subTaskName SUBTASKNAME deviceName DEVICENAME timeOfStart TIMEOFSTART timeOfFinish TIMEOFFINISH rollbackStatus ROLLBACKSTATUS #In Table AttributeAudit identifier IDENTIFIER retries RETRIES #In Table NotificationLog notiIndex NOTIINDEX #In Table NotificationLog logTime LOGTIME #In Table NotificationLog noVarBinds NOVARBINDS #In Table NotificationLog notiOID NOTIOID #In Table VarBindLog varIndex VARINDEX #In Table VarBindLog varType VARTYPE #In Table VarBindLog varValue VARVALUE lastModifiedTime LASTMODIFIEDTIME model MODEL contact CONTACT managedObjectName MANAGEDOBJECTNAME operationalStatus OPERATIONALSTATUS location LOCATION adminStatus ADMINSTATUS vendor VENDOR DHCPServer DHCPSERVER description DESCRIPTION variantId VARIANTID mapName MAPNAME #In Table INETService targetName TARGETNAME #In Table INETService targetAddress TARGETADDRESS #In Table INETService portNo PORTNO #In Table INETService protocolVersion PROTOCOLVERSION #In Table CollectData resourceName RESOURCENAME #In Table CollectData componentName COMPONENTNAME #In Table CollectData resourceType RESOURCETYPE #In Table CollectData configClass CONFIGCLASS #In Table CollectData dcClass DCCLASS #In Table CollectData dcXmlName DCXMLNAME #In Table CollectData dcDtdName DCDTDNAME #In Table CollectData storeData STOREDATA #In Table CollectData configured CONFIGURED #In Table CollectData applnDiscPort APPLNDISCPORT #In Table OracleCollectData userName USERNAME #In Table OracleCollectData password PASSWORD #In Table OracleCollectData instanceName INSTANCENAME #In Table OracleCollectData driverName DRIVERNAME #In Table OracleCollectData collectStaticData COLLECTSTATICDATA #In Table OracleCollectData state STATE #In Table OracleCollectData errorMsg ERRORMSG #For All ApplnData collectionTime COLLECTIONTIME #In Table InstanceDetails startupTime STARTUPTIME #In Table InstanceDetails created CREATED #In Table InstanceDetails openMode OPENMODE #In Table InstanceDetails logMode LOGMODE #In Table InstanceStatus dbsize DBSIZE #In Table InstanceStatus avgExecs AVGEXECS #In Table InstanceStatus avgUsers AVGUSERS #In Table InstanceStatus reads READS #In Table InstanceStatus writes WRITES #In Table InstanceStatus blockSize BLOCKSIZE #In Table SgaDetails bufferCacheSize BUFFERCACHESIZE #In Table SgaDetails sharedPoolSize SHAREDPOOLSIZE #In Table SgaDetails redologBufferSize REDOLOGBUFFERSIZE #In Table SgaDetails libraryCacheSize LIBRARYCACHESIZE #In Table SgaDetails dataDictCacheSize DATADICTCACHESIZE #In Table SgaDetails sqlAreaSize SQLAREASIZE #In Table SgaDetails fixedSize FIXEDSIZE #In Table SgaStatus freeMemorySize FREEMEMORYSIZE #In Table SgaStatus bufferHitRatio BUFFERHITRATIO #In Table SgaStatus dictionaryHitRatio DICTIONARYHITRATIO #In Table SgaStatus libraryHitRatio LIBRARYHITRATIO #In Table SessionInfo machine MACHINE #In Table SessionInfo elapsedTime ELAPSEDTIME #In Table SessionInfo cpuUsed CPUUSED #In Table SessionInfo memorySorts MEMORYSORTS #In Table SessionInfo tableScans TABLESCANS #In Table SessionInfo physicalReads PHYSICALREADS #In Table SessionInfo logicalReads LOGICALREADS #In Table SessionInfo diskSorts DISKSORTS #In Table SessionInfo blocksChanged BLOCKSCHANGED #In Table SessionInfo chainedRows CHAINEDROWS #In Table SessionInfo commits COMMITS #In Table SessionInfo cursors CURSORS #In Table SessionInfo buffercacheHitRatio BUFFERCACHEHITRATIO #In Table RollbackData segmentName SEGMENTNAME #In Table RollbackData tableSpaceName TABLESPACENAME #In Table RollbackData initialExtent INITIALEXTENT #In Table RollbackData nextExtent NEXTEXTENT #In Table RollbackData minExtent MINEXTENT #In Table RollbackData maxExtent MAXEXTENT #In Table RollbackData blocks BLOCKS #In Table RollbackData currentSize CURRENTSIZE #In Table RollbackData gets GETS #In Table RollbackData waits WAITS #In Table RollbackData hwmsize HWMSIZE #In Table RollbackData shrinks SHRINKS #In Table RollbackData wraps WRAPS #In Table RollbackData extend EXTEND #In Table DataFiles file_name FILE_NAME #In Table DataFiles createBytes CREATEBYTES #In Table DataFiles avgrdTime AVGRDTIME #In Table DataFiles avgwrTime AVGWRTIME #In Table RedoLogs thread THREAD #In Table RedoLogs sequence SEQUENCE #In Table RedoLogs bytes BYTES #In Table RedoLogs members MEMBERS #In Table RedoLogs archive ARCHIVE #In Table RedoLogs firstTime FIRSTTIME #In Table RedoLogs member MEMBER #In Table RedoLogs mstatus MSTATUS #In Table TableSpaceDetails allocatedBytes ALLOCATEDBYTES #In Table TableSpaceDetails allocatedBlocks ALLOCATEDBLOCKS #In Table TableSpaceDetails dataFiles DATAFILES #In Table TableSpaceStatus freeBytes FREEBYTES #In Table TableSpaceStatus freeBlocks FREEBLOCKS #In Table TableSpaceStatus readtime READTIME #In Table TableSpaceStatus writetime WRITETIME #In Table HostDetails userName USERNAME #In Table HostDetails password PASSWORD #In Table HostDetails prompt PROMPT #In Table HostDetails osType OSTYPE #In Table HostDetails category CATEGORY #In Table HostDetails errorMsg ERRORMSG #In Table HostDetails loginPrompt LOGINPROMPT #In Table HostDetails passwordPrompt PASSWORDPROMPT #In Table HostDataCollected curValue CURVALUE #In Table HostDataCollected category CATEGORY #In Table HostDataCollected entity ENTITY #In Table STATSDATA_HOURLY, STATSDATA_DAILY pollid POLLID instance INSTANCE val VAL minvalue MINVALUE maxvalue MAXVALUE tinterval TINTERVAL #In Table OpManagerObject dependent DEPENDENT debounceCount DEBOUNCECOUNT ramSize RAMSIZE hardDiskSize HARDDISKSIZE upDependency UPDEPENDENCY OS OS profile PROFILE encoding ENCODING #In Table AccessPoint sysDescription SYSDESCRIPTION macAddress MACADDRESS sysLocation SYSLOCATION sysUpTime SYSUPTIME vendor VENDOR model MODEL firmwareVersion FIRMWAREVERSION APRole APROLE APDiscoveryType APDISCOVERYTYPE APType APTYPE #In Table NeighborAPs neighborAP NEIGHBORAP #In Table DeviceCLIDetails credentialID CREDENTIALID protocol PROTOCOL port PORT prompt PROMPT loginPrompt LOGINPROMPT passwordPrompt PASSWORDPROMPT enablePrompt ENABLEPROMPT enablePassword ENABLEPASSWORD #In Table MobileUnit MUType MUTYPE MUMacAddress MUMACADDRESS powerMode POWERMODE MUVendor MUVENDOR MUModel MUMODEL MUDataRate MUDATARATE associationStatus ASSOCIATIONSTATUS ssid SSID APName APNAME associationTime ASSOCIATIONTIME firstSeenTime FIRSTSEENTIME lastSeenTime LASTSEENTIME #In Table SensorObject sendProbe SENDPROBE discardErrors DISCARDERRORS channelDwellTime CHANNELDWELLTIME statisticalInterval STATISTICALINTERVAL snapshotLength SNAPSHOTLENGTH webKey1 WEBKEY1 value1 VALUE1 webKey2 WEBKEY2 value2 VALUE2 webKey3 WEBKEY3 value3 VALUE3 webKey4 WEBKEY4 value4 VALUE4 channelBitmap CHANNELBITMAP channelSurf CHANNELSURF webDecrypt WEBDECRYPT #In Table MUSingalStrengthHistory associatedAP ASSOCIATEDAP signalQuality SIGNALQUALITY #In Table RadioInterface interfaceMacAddress INTERFACEMACADDRESS interfaceName INTERFACENAME interfaceIndex INTERFACEINDEX interfaceStatus INTERFACESTATUS #In Table RadioInterface parentNode PARENTNODE operationMode OPERATIONMODE channel CHANNEL beaconRate BEACONRATE preamble PREAMBLE transmitPower TRANSMITPOWER modulation MODULATION dataRate DATARATE phyType PHYTYPE signalStrength SIGNALSTRENGTH noiseLevel NOISELEVEL lastSeen LASTSEEN firstSeen FIRSTSEEN nearestSensor NEARESTSENSOR #In Table SSIDDetails name NAME apssid APSSID encryptionType ENCRYPTIONTYPE authType AUTHTYPE mode MODE vlanid VLANID #In Table RadiusServer authport AUTHPORT timeOut TIMEOUT maxRetries MAXRETRIES sharedsecret SHAREDSECRET #In Table AssociationHistory recordID RECORDID MUName MUNAME APName APNAME timeValue TIMEVALUE category CATEGORY description DESCRIPTION ssid SSID #In Table GroupDetails groupID GROUPID groupName GROUPNAME groupDescription GROUPDESCRIPTION groupType GROUPTYPE #In Table DeviceGroupMapping groupID GROUPID deviceID DEVICEID #In Table GroupCriteria criteriaID CRITERIAID propertyName PROPERTYNAME propertyValue PROPERTYVALUE #In Table FirmwareImage deviceType DEVICETYPE deviceModel DEVICEMODEL bootFileName BOOTFILENAME #In Table FirmwareTaskDetails scheduleType SCHEDULETYPE scheduleTime SCHEDULETIME restoreConfiguration RESTORECONFIGURATION #For Tables Alert and Event alarmType ALARMTYPE alarmId ALARMID #In Table ConfigHistory recordID RECORDID historyType HISTORYTYPE deviceName DEVICENAME timeValue TIMEVALUE status STATUS message MMESSAGE # In Table AlertExpert enabled ENABLED severity SEVERITY class CLASS summary SUMMARY message MMESSAGE description DESCRIPTION action ACTION customprotect CUSTOMPROTECT groupName GROUPNAME alarmsbypoll ALARMSBYPOLL detailsurl DETAILSURL clearmsg CLEARMSG ############### Gateway devices. ###################### #In Table Gateway gwNoOfClients GWNOOFCLIENTS gwNoOfAuthUsers GWNOOFAUTHUSERS gwNoOfUnAuthUsers GWNOOFUNAUTHUSERS #In Table GatewayPort gwPortIndex GWPORTINDEX gwPortMacAddress GWPORTMACADDRESS gwPortDescriptor GWPORTDESCRIPTOR gwPortSpeed GWPORTSPEED ############### Gateway devices. ###################### isPrimary ISPRIMARY ############### NomadixGateway devices. ###################### # Table WifiObject wifiVendor WIFI_VENDOR wifiModel WIFI_MODEL wifiFirmwareVersion WIFI_FIRMWAREVERSION wifiLocation WIFI_LOCATION wifiFirstSeenTime WIFI_FIRSTSEENTIME wifiLastSeenTime WIFI_LASTSEENTIME wifiLastSyncTime WIFI_LASTSYNCTIME wifiSysUpTime WIFI_SYSUPTIME # Table NomadixGateway nmType NM_TYPE nmGatewayID NM_GATEWAYID nmBridgeMode NM_BRIDGEMODE #Table SubscriberCurrentTable sctSubIndex SCT_SUBINDEX sctSubName SCT_SUBNAME sctIpAddress SCT_IPADDRESS sctMacAddress SCT_MACADDRESS sctPort SCT_PORT sctUploadBandwidth SCT_UPLOADBANDWIDTH sctDownloadBandwidth SCT_DOWNLOADNBANDWIDTH sctExpiration SCT_EXPIRATION sctState SCT_STATE sctTimeout SCT_TIMEOUT sctBytesSend SCT_BYTESSENT sctBytesReceived SCT_BYTESRECEIVED sctProxy SCT_PROXY sctTime SCT_TIME sctKey SCT_KEY #Table NMStaticPortMappingTable nmspm_index NMSPM_INDEX nmspm_internalMAC NMSPM_INTERNALMAC nmspm_internalIP NMSPM_INTERNALIP nmspm_internalPort NMSPM_INTERNALPORT nmspm_externalIP NMSPM_EXTERNALIP nmspm_externalPort NMSPM_EXTERNALPORT nmspm_remoteIP NMSPM_REMOTEIP nmspm_remotePort NMSPM_REMOTEPORT nmspm_protocol NMSPM_PROTOCOL # Table NomadixRI nmBroadcastOn NM_BROADCASTON nmChannel NM_CHANNEL nmDataRate NM_DATARATE nmBeaconInterval NM_BEACONINTERVAL nmDTIM NM_DTIM nmTransmitPower NM_TRANSMITPOWER nmFragmentLength NM_FRAGMENTLENGTH nmRTSLength NM_RTSLENGTH nmShortPreambleOn NM_SHORTPREAMBLEON nmSSID NM_SSID nmNearestSensor NM_NEARESTSENSOR nmSignalStrength NM_SIGNALSTRENGTH nmNoiseLevel NM_NOISELEVEL ############### NomadixGateway devices. ###################### ############### Wireless Switch devices. ###################### # In Table WirelessSwitch ws_id WS_ID ws_upTime WS_UPTIME ws_discoveryType WS_DISCOVERYTYPE ws_macAddress WS_MACADDRESS ws_vendor WS_VENDOR ws_model WS_MODEL ws_firmwareVersion WS_FIRMWAREVERSION ws_location WS_LOCATION # In Table WirelessSwitchPort ws_poe WS_POE ws_parentSwitch WS_PARENTSWITCH ws_type WS_TYPE ws_power WS_POWER ws_configSpeed WS_CONFIGSPEED ws_duplex WS_DUPLEX # In Table ThinAP ws_portName WS_PORTNAME ############### Wireless Switch devices. ###################### # In the Table ExpertAlertToNotification profileId PROFILE_ID # In the Table NotificationProfile profileType PROFILETYPE profileName PROFILE_NAME # In the Table NotificationProfile emailMessage MAIL_MESSAGE # In the Table NotificationProfile mailFrom MAIL_FROM subject SUBJECT # In the Table mailids mailTo MAIL_TO # In the Table PlaySoundNotification soundFileName SOUNDFILENAME # In the Table RunSystemCommand command COMMAND # In the Table TrapNotification managerName MANAGERNAME