tips & tricks


Calendario
dicembre 2024
lmmgvsd
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

CRM Client Local Data Group

Gestire i Local DataGroup nel CRM4.0 non è certo cosa semplice, visto che bisogna configurarli per ogni singolo client su cui è installato il crm outlook client.

Purtroppo ancora non cè un modo centralizzato da dove poter andare a settare i LDG, ma si può andare sul DB a capire la configurazione per ogni client, quindi controllare che sia corretta, con una query del tipo:

SELECT
SU.fullname,
SU.mp_code,
SU.businessunitidname,
UQB.name,
UQB.FetchXml
FROM
 [OrgName_MSCRM].[dbo].UserQueryBase UQB  
      INNER JOIN [OrgName_MSCRM].[dbo].SystemUser SU ON SU.SystemUserId = UQB.OwningUser
WHERE SU.IsDisabled = 0
AND UQB.DeletionStateCode = 0
AND UQB.StateCode = 0
AND ISNULL(UQB.StatusCode, 0) <> 2
AND UQB.QueryType = 16
AND UQB.FetchXml LIKE '%eq-userid%'
AND UQB.name LIKE 'my%'
AND UQB.name NOT IN (
                    'My Area Managers',
                    'My Contracts',
                    'My Importers',
                    'My LogEntities',
                    'My OnlyForTests',
                    'My Recent Case Resolution Activities',
                    'My Recent Cases',
                    'My Recent Invoices',
                    'My Recent Opportunities',
                    'My Recent Opportunity Close Activities',
                    'My Recent Order Close Activities',
                    'My Recent Orders',
                    'My Recent Quote Close Activities',
                    'My Recent Quotes',
                    'My Visibility Tables'
                   )
ORDER BY
 1,4
 

OPPURE

SELECT
 SU.fullname,
 SU.mp_code,
 SU.businessunitidname,
 COUNT(*) groups
FROM
 [OrgName_MSCRM].[dbo].UserQueryBase UQB INNER JOIN
      [OrgName_MSCRM].[dbo].SystemUser SU ON SU.SystemUserId = UQB.OwningUser
WHERE
SU.IsDisabled = 0
AND UQB.DeletionStateCode = 0
AND UQB.StateCode = 0
AND ISNULL(UQB.StatusCode, 0) <> 2
AND UQB.QueryType = 16
AND UQB.FetchXml LIKE '%eq-userid%'
AND UQB.name LIKE 'my%'
AND UQB.name NOT IN (
                      'My Area Managers',
                      'My Contracts',
                      'My Importers',
                      'My LogEntities',
                      'My OnlyForTests',
                      'My Recent Case Resolution Activities',
                      'My Recent Cases',
                      'My Recent Invoices',
                      'My Recent Opportunities',
                      'My Recent Opportunity Close Activities',
                      'My Recent Order Close Activities',
                      'My Recent Orders',
                      'My Recent Quote Close Activities',
                      'My Recent Quotes',
                      'My Visibility Tables'
                     )
GROUP BY
 SU.fullname,
 SU.mp_code,
 SU.businessunitidname
ORDER BY
 4,1

 

 

Categoria: CRM 4.0
lunedì, 08 giu 2009 Ore. 17.17
Archivio Posts
Anno 2020

Anno 2018

Anno 2015

Anno 2013

Anno 2011

Anno 2010

Anno 2009

Anno 2008
Statistiche
  • Views Home Page: 15.071
  • Views Posts: 58.248
  • Views Gallerie: 2.837
  • n° Posts: 117
  • n° Commenti: 1
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003