nobody knows? Anyone know what table or view holds the "Types" of relations?
On Mon, Jul 22, 2013 at 1:46 PM, Todd Hemsell <[email protected]> wrote: > What does this field mean? Is_Assigned_To_User0. It does not seem to > relate to the User Machine Relation views. None of my machines have been > assigned to a user, but I do have top console user for most all of them. I > set it to not automatically configure usage data. > > The Is_Assigned_To_User0 field has a value of 1 for all of my systems > except 1 > > > Left Join v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP MG on VRS.ResourceID = MG. > ResourceID > > Left Join v_UserMachineRelation UMR ON UMR.RelationshipResourceID = VRS. > ResourceID > > Left Join v_UserMachineTypeRelation UMTR ON UMTR.RelationshipResourceID = > VRS.ResourceID > > Left Join v_UserMachineSourceRelation UMSR on UMSR.RelationshipResourceID > = VRS.ResourceID > > > [image: Inline image 1] > >
<<User Affinity.jpg>>
