Dict-Physical

View VMD_ProgramOrApp

Card of view VMD_ProgramOrApp

Name	VMD_ProgramOrApp
Comment	See documentation on MD_ProgramOrApp in the StarsLabUsage package. Used in conjunction with VMF_KeyedComputerEvent.
Dimensional Type	Dimension

SQL query of the view VMD_ProgramOrApp

select
MD_Program_SurrogateKey,
MD_Program_UniqueID,
MD_Program_SystemOfRecord,
MD_Program_Name,
MD_Program_Version,
MD_Program_VariantName,
MD_Program_VariantVersion,
MD_Program_Publisher,
MD_Program_Platform
from
MD_ProgramOrApp

List of incoming view references of the view VMD_ProgramOrApp

ViewReference_226

VMF_KeyedComputerEvent

List of referenced objects of the view VMD_ProgramOrApp

MD_ProgramOrApp

List of diagrams containing the view VMD_ProgramOrApp

ViewsLabUsageDiagram

List of permissions of the view VMD_ProgramOrApp

SELECT,VIEW DEFINITION

IssueTrackingReader

List of view columns of the view VMD_ProgramOrApp

MD_Program_SurrogateKey

numeric

MD_Program_UniqueID

varchar(36)

K2 unique BINARY(20) value converted to a GUID using the following code (C# in SSIS):

// Then convert the same byte array to a GUID and store it in the Unique ID field
MD5CryptoServiceProvider cProvider = new MD5CryptoServiceProvider();
byte[] hash = cProvider.ComputeHash(buf);
Guid myGuid = new Guid(hash);
Output0Buffer.UNTRIMMEDCHARUniqueID = myGuid.ToString();

MD_Program_SystemOfRecord

varchar(64)

Until we add data from another keyserver, the data here will all come from K2, and "K2" will be the only value present.

MD_Program_Name

nvarchar(64)

Whatever mnemonic or name is assigned to a particular program being run. Might be the name of the license monitoring software itself.

MD_Program_Version

varchar(64)

Version of program being run (usually contains digits and periods, like 1.3), but may contain other characters.

MD_Program_VariantName

nvarchar(64)

MD_Program_VariantVersion

varchar(64)

MD_Program_Publisher

nvarchar(64)

Publisher of a given software package. Corresponds to the manufacturer in the case of hard assets.

MD_Program_Platform

nvarchar(64)

Corresponds to KStermPlatform table in K2, termAbbreviation field. KStermPlatform joins to programPlatform field in KSPrograms on termID = programPlatform. Typically designates the operating system (or in the case of Apple computers running OS/X and iDevices, we use 'Macintosh').

Home