Archive for the ‘RnD’ Category

Script to Add all users to a AD group

Sunday, April 16th, 2006

How to Back and Restore Project DB

Friday, February 17th, 2006

Moving DBs in PS2003 Environment

Monday, December 12th, 2005

How to move the databases that are used by Windows SharePoint Services and by Project Server 2003 to a computer that is running SQL Server

Query Resources With Project Authentication With No GUID

Monday, December 12th, 2005

Run this query against Project server database.

select Res_UID, Res_name, Res_AD_Guid from msp_resources where Res_name <> ” AND Res_AD_Guid is null order by Res_name

Query1 To list Project Plans without WSS site

Monday, December 12th, 2005

The following query lists the Project plans in Project Server 2003 which doesn’t have their WSS configured alongwith their ProjID & Wproj_ID.. Run this query against your Project Server database.

select proj_name, proj_id, wproj_id, wproj_sts_subweb_name from msp_web_projects where wproj_sts_subweb_name like ‘none’ order by proj_name

(I can’t guarantee issues which might arise due tho this code.)

Later you can use Manage SharePoint sites page & create WSS sites for the project plans in the list.

Query to Delete Timesheet messages on PWA Home

Wednesday, December 7th, 2005

insert  MSP_WEB_WORK_APPROVAL(
WASSN_ID,
WRES_ID,
WPRD_START_DATE,
WPRD_FINISH_DATE,
WRES_ID_APPROVER,
WAPPROVAL_STATUS,
WAPPROVAL_NOTIFICATION_SENT)
SELECT WASSN_ID,
WRES_ID,
WPRD_START_DATE,
WPRD_FINISH_DATE,
WRES_ID,
1,
0
FROM MSP_WEB_ASSIGNMENTS MWA, MSP_WEB_TIME_PERIODS mwp
WHERE Not Exists (select * from MSP_WEB_WORK_APPROVAL
where CONVERT(VARCHAR, CONVERT(DATETIME, WPRD_START_DATE), 110) = CONVERT(VARCHAR, CONVERT(DATETIME, MWP.WPRD_START_DATE), 110)
  AND CONVERT(VARCHAR, CONVERT(DATETIME, WPRD_FINISH_DATE), 110) = CONVERT(VARCHAR, CONVERT(DATETIME, MWP.WPRD_FINISH_DATE), 110)
  AND WASSN_ID = MWA.WASSN_ID
  AND WRES_ID = MWA.WRES_ID)

Go

UPDATE MSP_WEB_WORK_APPROVAL
SET WAPPROVAL_STATUS = ‘1’
WHERE WAPPROVAL_STATUS = ‘0’

go

Query to find resrouces with unsubmitted timesheet

Monday, November 14th, 2005

— attempt to id non-reporters
–find full list of resources
select wr.res_name
from MSP_WEB_RESOURCES WR,MSP_TEXT_FIELDS TXTFLD, MSP_CONVERSIONS CONV
where WR.RES_EUID = TXTFLD.TEXT_REF_UID
and  TXTFLD.TEXT_FIELD_ID = CONV.CONV_VALUE
and TXTFLD.text_category = 1
and proj_id = 1
and conv_string = ‘Resource Group’
and wr.RES_NAME not in
        ( — list of resources who have pending task updates.
                select distinct R.RES_NAME
                from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P, MSP_WEB_RESOURCES R
                where A.WASSN_ACTUALS_PENDING =1 — flag to indicate task is pending manager approval
                and A.wproj_id = P.WPROJ_ID
                AND R.WRES_ID = A.WRES_ID
        )
order by res_name

MS Project KB Sites

Thursday, October 27th, 2005

MS Project Server KB Articles Home
http://support.microsoft.com/ph/2526

MS Project KB Articles Home
http://support.microsoft.com/ph/2525/en-us

New Reporting Tools For SharePoint Portal Server

Monday, October 17th, 2005