Stores software definition attributes. Attributes that comprise software definitions related to software detected by UAM and reconciled by Asset Intelligence.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| swuuid | byte(16) | not null | Unique identifier for related publisher definition |
| pubuuid | byte(16) | not null | Unique identifier for related publisher definition |
| swpub | nvarchar(128) | not null | |
| swname | nvarchar(128) | not null | Software application name |
| swver | nvarchar(128) | not null | Software version code |
| swrel | nvarchar(128) | not null | Software release code |
| swmod | nvarchar(128) | not null | Software mod code |
| swnote | nvarchar(128) | not null | |
| swbld | nvarchar(128) | not null | Software build code |
| swlang | nvarchar(128) | not null | |
| laction | nvarchar(32) | not null | Last action code (i.e., "ADDED", "MODIFIED") |
| lactdate | date | not null | Date of last action |
Product Name: Unicenter Asset Intelligence
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| swuuid | pubappcomputers | swname |
| swuuid | pubappcacomputers | swname |
| swuuid | ai_swdef_instcnt_kpi | swuuid |
| swuuid | ai_swdef_hwdef_rel | swuuid |
| swuuid | ai_swcat_swdef_rel | swuuid |