| |
|
 |
Sunday, September 07, 2008
|
|
|
Resources » Simple SQL
|
|
|
Simple SQL - Find all Table Sizes
BEGIN try
DECLARE @table_name VARCHAR(500) ;
DECLARE @schema_name VARCHAR(500) ;
DECLARE @tab...
Simple SQL - How to Rest DNN Host Password
Declare @UserName NVarChar(255)
Declare @NewPassword NVarChar(255)
Declare @PasswordSalt NVa...
Simple SQL - Number of times a module is used across all portals
SELECT ModuleName, 'Instances' = count(*)
FROM DesktopModules
INNER JOIN ModuleDefinitions ...
Simple SQL - New Users per day
SELECT DAY(CreatedDate) as 'Day', DATENAME(m , CreatedDate) as Month, YEAR(CreatedDate) as 'Year', ...
Simple SQL - New Users per month including average per day over month
SELECT DATENAME(m , CreatedDate) as Month, YEAR(CreatedDate) as 'Year', COUNT(*) as 'New Users', CO...
SQL for DNN 3.x - Show all Affiliate incoming clicks by Vendor
SELECT VendorName, Clicks FROM Affiliates A INNER JOIN Vendors V ON A.VendorId = V.VendorId WHERE V....
SQL for DNN 3.x - Various User Reports
Here are some great queries from the Venexus DotNetNuke Blog Definitely worth having a look a...
SQL for DNN 3.x - Querying Member Profile Data
I won't copy Richard's good work, but you can read the article here for
more information of extract...
SQL for DNN 3.x - Determing Size of Database Objects
Some useful advice if you DNN installation is slow or you want to know if your database is too lar...
SQL for DNN 3.x - Changing a password of a user to one you know
--Get info from user you know
SELECT * FROM aspnet_Users aU, aspnet_Membership aM, Users U
WHERE...
SQL for DNN 3.x - Bulk Deletion of Users based on query
Problem : Corresponding user records stored in aspnet membership tables, keyed on lowered username ...
SQL for DNN 3.x - How to link to a page based on a query
SELECT ' a HREF=/default.aspx?tabid=' +
CAST(TabID AS VARCHAR) + ' ' + T.TabName + ' /a '
FROM Ta...
SQL for DNN 3.x - Show all Users that belong to Roles about to expire
SELECT DISTINCT(UR.UserID), U.FirstName, U.LastName, R.RoleName, ExpiryDate
FROM USERROLES UR
IN...
SQL for DNN 3.x - View all Registered Users (Submitted by Leif Leiner)
SELECT U.Username, U.Firstname, U.Lastname, R.Rolename, AM.Email
FROM Users U
INNER JOIN UserRol...
SQL for DNN 3.x - Show all banner clickthroughs from active Vendors
SELECT V.VendorName, BannerName, B.Views, B.ClickThroughs, B.Impressions
FROM Banners B
INNER...
|
|
|
|
|