ADAM
|
o Asset, asset objects, asset reconciliation rules, site, tags
o Predefined/customer standards, sections, checks, algorithms
|
Database
|
· Job results
|
ADAM and database
|
|
Value
|
Description
|
CN
|
cn: 72875e8c-9a57-4345-b2b1-edf36b60d98e
|
Asset GUID
|
objectGUID: b02daf3b-44aa-4c03-a2d5-8b225dee196a;
|
ObjectClass
It means that this object is an object of Windows machine. The object is derived from the Asset base.
|
objectClass (4): top; symc-LeafNode; symc-csm-AssetSystem-Asset-AssetBase; symc-csm-AssetSystem-Asset-Wnt-Machine;
|
CIA values of set on the asset
|
symc-csm-AssetSystem-Asset-AssetBase-Availability: 0;
symc-csm-AssetSystem-Asset-AssetBase-Confidentiality: 0;
symc-csm-AssetSystem-Asset-AssetBase-Integrity: 0;
|
Compliance and risk scores
|
symc-csm-AssetSystem-Asset-AssetBase-EvaluatedComplianceScores: SM:40.68;
symc-csm-AssetSystem-Asset-AssetBase-EvaluatedRiskScores: SM:6.9;
symc-csm-AssetSystem-Asset-AssetBase-MaxRiskScores: SM:10;
|
Site where this asset belongs
|
symc-csm-AssetSystem-Asset-AssetBase-Site: CN=fbaba418-8062-4996-bb71-a89840571113,CN=Sites,CN=Asset Management,CN=BusinessObjects,O=Symantec;
|
Asset primary and mandatory attributes of the asset
|
symc-csm-AssetSystem-Asset-Wnt-Machine-BDC: FALSE;
symc-csm-AssetSystem-Asset-Wnt-Machine-DomainWorkgroupName: KANAD;
symc-csm-AssetSystem-Asset-Wnt-Machine-HostMachineInDomain: TRUE;
symc-csm-AssetSystem-Asset-Wnt-Machine-HostName: NGESX1VM01;
symc-csm-AssetSystem-Asset-Wnt-Machine-HostNameDNS: ngesx1vm01.kanad.punetest.com;
symc-csm-AssetSystem-Asset-Wnt-Machine-IISVERSION: Version 6.0;
symc-csm-AssetSystem-Asset-Wnt-Machine-OSMajorVersionNumber: 5;
symc-csm-AssetSystem-Asset-Wnt-Machine-OSMinorVersionNumber: 2;
symc-csm-AssetSystem-Asset-Wnt-Machine-OSVersionType: Windows Enterprise Server 2003 with Terminal Services;
symc-csm-AssetSystem-Asset-Wnt-Machine-PDC: FALSE;
symc-csm-AssetSystem-Asset-Wnt-Machine-Server: TRUE;
symc-csm-AssetSystem-Asset-Wnt-Machine-TCPIPAddresses: 10.216.134.102;
symc-Node-TypeName: symc-csm-AssetSystem-Asset-Wnt-Machine;
|
To get the Asset ID
|
select * from Dashboard.vAsset where assetname = 'kanad\ngesx1vm01’
|
To get the standard ID
|
select * from dbo.ivStandardName where StandardName = 'CIS Windows Server 2003 Legacy Security Settings for Domain Member Servers v2.0'
|
ShuntedResultSTR
|
Contains temporary XML fragments for assets, checks, and results data.
|
ShuntedResultSTRD
|
Contains temporary XML fragments of assets, checks, and results details data.
|
ShuntedResultSTRE
|
Contains temporary XML fragments of evidence data.
|
ShuntedXMLEntity
|
Contains standards, checks, assets, and objects against which evaluations can be performed.
|
ShuntedXMLRelationship
|
Contains temporary XML fragments relationship of entities such as asset - asset group, asset to container and so on.
|
F14F2032-AE57-4B93-A769-31422A792FBD
|
NULL
|
NULL
|
Start
|
2012-02-02 15:08:26.980
|
Lot of log entries for a sync operation resides between these 2 lines.
|
|
|
|
|
F14F2032-AE57-4B93-A769-31422A792FBD
|
NULL
|
NULL
|
end
|
2012-02-02 15:11:28.740
|
In production database
(CSM_DB)
|
After you have configured a connector, run the following query:
select * from dbo.ThirdPartySystem
select * from DataIntegration.ConnectorConfiguration
You will notice that with 10.5.1 out of the box, the following EDI systems are registered:
· CCS Response Assessment Module
· CCS Vulnerability Manager
· Data Loss Prevention
On configuring MBSA, an entry is created in the ThirdPatrySystem table and a corresponding configuration is created in the DataIntegration.ConnectorConfiguration table.
|
In reporting database
(CSM_Reports)
|
On executing the following queries, you will get definition of data system schemas and UDM representation of the incoming data:
select * from dbo.Source
select * from dbo.SourceEntity
select * from dbo.SourceEntityAttribute where UDMEntityName = 'MBSAschemaSubject'
OR UDMEntityName = 'MBSAschemaTest'
After the data is imported, data is populated in the following tables and dynamic views:
Tables:
select * from dbo.ExtendedResultsMBSAschemaSubjectMBSAschemaTest
select * from dbo.ExtendedEntityMBSAschemaSubject
select * from dbo.ExtendedEntityMBSAschemaTest
Dynamic views:
DynamicViewMBSAschema
DynamicViewMBSAschemaSubject
DynamicViewMBSAschemaTest
|