Catalog Item Details Report

[prashantmirya]

know this is a old and not related question i am asking again here, but would like to know all catalog items created for last year and their details report.

could some one help me

[CharlesW · Accepted solution]

The following query shoud get you headed in the right direction:

select CreatedOn, PackageTitle, PackageDesc from wd_webpackages where CreatedOn >= DATEADD(year,-1,GETDATE())

The WD_Webpackages table contains the majority of information about all of your catalog items.

[CharlesW · Accepted solution]

The following query shoud get you headed in the right direction:

select CreatedOn, PackageTitle, PackageDesc from wd_webpackages where CreatedOn >= DATEADD(year,-1,GETDATE())

The WD_Webpackages table contains the majority of information about all of your catalog items.

[prashantmirya]

appreciate your quick response, finally i got one solution very quick.

[prashantmirya]

need another help please, we are trying to build a report with all catalog items in portal and their associate package id in SCCM

[jdempsey · Accepted solution]

The WD_SiteToAdvert table should have details about the SCCM packages tied to catalog items.  You should be able to join that table with your previous report (WD_WebPackages) to get the report you're looking for.