View ESEC.ESECDBA.EVT_ASSET_RPT_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 04 17:09 EDT 2010 |
View SQL:
SELECT EVT_ASSET_ID as Event_Asset_ID, CUST_ID, ASSET_NAME as Asset_Name, PHYSICAL_ASSET_NAME as Physical_Asset_Name, REF_ASSET_ID as Reference_Asset_ID, MAC_ADDR as Mac_Address, RACK_NUM as Rack_Number, ROOM_NAME as Room_Name, BUILDING_NAME as Building_Name, CITY as City, STATE as State, CNTRY as Country, ZIP_CD as Zip_Code, ASSET_CTGRY_NAME as Asset_Category_Name, NETWORK_IDENTITY_NAME as Network_Identity_Name, ENV_IDENTITY_NAME as Environment_Identity_Name, ASSET_VAL_NAME as Asset_value_Name, CRIT_NAME as Criticality_Name, SENSITIVITY_NAME as Sensitivity_Name, CONTACT_NAME_1 as Contact_Name_1, CONTACT_NAME_2 as Contact_Name_2, ORGANIZATION_NAME_1 as Organization_Name_1, ORGANIZATION_NAME_2 as Organization_Name_2, ORGANIZATION_NAME_3 as Organization_Name_3, ORGANIZATION_NAME_4 as Organization_Name_4, DATE_CREATED, DATE_MODIFIED, CREATED_BY, MODIFIED_BY FROM EVT_ASSET |
|