welcome to XRM blog

SharePoint SQL Query to Get the Site Names, Site List & Libraries

SELECT

Webs.Title AS 'Site Name',

AllLists.tp_Title AS 'List Name',

AllDocs.DirName AS 'List Partial URL',

count(1) as 'Record Count'

FROM AllDocs

JOIN AllLists

ON AllLists.tp_ID = AllDocs.ListId

JOIN Webs

ON Webs.Id = AllLists.tp_WebId

WHERE

  Webs.FullUrl like 'client/%'

group by Webs.Title,AllLists.tp_Title, AllDocs.DirName

ORDER BY Webs.Title

To see the actual record we need to run the following query

 SELECT Webs.Title AS 'Site Name',

AllLists.tp_Title AS 'List Name',

AllDocs.DirName   AS 'List Partial URL',

AllDocs.LeafName  AS 'File Name',

AllDocs.ExtensionForFile AS 'Type',

AllDocs.TimeCreated AS 'Date Created'

FROM AllDocs

JOIN AllLists

ON AllLists.tp_ID = AllDocs.ListId

JOIN Webs

ON Webs.Id = AllLists.tp_WebId

WHERE

Webs.FullUrl like 'client/a%'

ORDER BY Webs.Title

Step 1: How to View/Review the current Site Collection Settings

Introduction of Exchange Currency Rate-

Recently in my current Project There is a requirement to generate a report on click of custom ribbon button, So I thought of writing this JavaScript code.

CRM stands for “Customer Relationship Management”. Dynamics CRM is a software package developed by Microsoft for managing a company’s connections with its present and future customers.

Recently we were faced with a unique challenge. One of our mobile apps was posting images to our WebAPI as a Multipart/Form-Data but our WebAPI was unable to receive the byte array and returned null each time. The WebAPI in question was written for an older MVC application. For the Mobile App, the problem was the function was not able to use HttpPostedFileBase class. 

These days we hear so much about cloud computing as it’s been one of the major IT buzz for the past few years, ‘Cloud Computing’ has brought a new era with an incredible promise to the world of information technology. Cloud computing interest among the people has grown rapidly and has led to widespread curiosity and awareness of cloud services amongst the public.

From last couple of years Microsoft has been pushing its business solutions very hard to cover as many areas as possible while keeping things simpler. To understand how the Dynamics 365 for Sales, Business Edition came to existence as a separate App.