-
I am looking to create a similar report to Site Group Membership. However, I need to you a filter to enum all users in a certain group named "Bill To" So I invesitated and found the Stored Procedure that Quest uses in their report For your SQL Query Gurus, Can someone modify this into include...
-
Here is the current script provided by the software. Without butchering it how can I change to "Greater than 30 days". We want to schedule this script daily to delete items older than 30 days. Thank you for your expertise DECLARE @StartTimeGMT datetime, @EndTimeGMT datetime SET @StartTimeGMT...
-
Using the Quest Reports we notice that when a user is removed from a SharePoint Group it is not updated in the qspsgroupmembership table. Action 1) User Added to a SharePoint Group - After gathering this is reflected in the report 2) User Removed from a SharePoint Group - After gathering this is not...
-
Here is what I had used to delete all account that contains 'entprd' Delete DB from QSPSSTSLog AS DB WHERE Exists( SELECT QSPSSTSLog.ID, QSPSSTSLog.DateTime, QSPSSTSLog.SiteID, QSPSSTSLog.UserID, QSPSSTSLog.DocID, QSPSSTSLog.Bytes, QSPSUsers.Login, QSPSUsers.Title FROM QSPSSTSLog INNER JOIN QSPSUsers...
-
Thank you G.V These queries above assisted me troubleshooting what was going wrong. I have a maintenance script running that would delete entries from the QSPSSTSLog where the USERID was the system. There is something definitely wrong with this script. As a result my QSPSSTSLog has only 24 hrs worth...
-
After the 3.5.2 Upgrade, I can see there is data logged in the QSPSSTSLog, QSPSVirtualServerPer, QSPSVirtualServerPerfTrend, QSPSWebTrends. However, the Quest OOTB Report "Hit Count Trend" and "Traffice Usage" do not show any data Any assistance why this doesnt appear? I have verified...
-
Somehow, I think that upgrading and upgrading my Site Admin to 3.5 I feel that the OOTB Quest Reports may have been not updated. Without completely reinstalling, I want to reprovision the Quest Built In Reports. By default the Quest Reports are located in the SharePoint reports folder. I want to re upload...
-
I thought I'd start a nice to have thread....One of the most challenging aspects of SharePoint is the maintenance and governance of a farm. It would be nice to address such issues using the reporting feature from Site Admin MOSS Configuration Excessive Keywords Per Site Excessive Managed Properties...
-
There are 3 columns of interest BytesSended TimeTaken HitCount I am trying to wrap my head around to which performance counter is the TimeTaken mapped. I am guessing its on of the counters under WebService is this Get Request Per Sec?