This script will find custom Parental or Cascading Relationship between entities in CRM. This script was used to determine if someone had changed a relationship on a target system and if that change was causing an import to fail.
FROM [DefenseReady_MSCRM].[MetadataSchema].[Relationship] REL
left join DefenseReady_MSCRM.MetadataSchema.Entity Referencing_Entity on REL.ReferencingEntityId = Referencing_Entity.EntityId
left join DefenseReady_MSCRM.MetadataSchema.Entity Referenced_Entity on REL.ReferencedEntityId = Referenced_Entity.EntityId
left join DefenseReady_MSCRM.MetadataSchema.Attribute Re…
I don't do custom SSRS to often but when I do I consonantly have issues pre-filtering FetchXML in SSRS reports. The items below are what I have found to be the total set of requirements to make sure it works.
Example: Let's say we have an entity called 'new_house'. Below is the FetchXML statement I would use in the data set.
After completing the setup of the RDS/RDWeb on Windows Server 2012 R2 we were unable to use the "Connect to a PC" functionality. When attempting to connect the following error:
Remote Desktop can't find the computer "". This means that "" does not belong to the specific network. Verify the computer name and domain that you are trying to connect to"
The fix for this is to go into the IIS Manager on the RDS server. -Go to Server -> Sites -> Default Web Site -> RDWeb -> Pages -Click on Application Settings. -Modify the DefaultTSGateway setting by entering the FQDN of your RDS server. eg(rds.richardawilson.lab)