Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

List of active users on Sharepoint

  Asked By: Jim Dominguez         Date: Jan 10, 2010      Category: Sharepoint      Views: 621
 

Im the IT Manager & im handling sharepoint portal server.
My COO contacts me & asks ----

1. How many people are using SharePoint in the company?
2. How many sites are active?
3. How many users are having access to sites (& at which level)?

Is this can be done on Sharepoint server or i need 3rd party software??
Im confuse how i can do this.

Tagged:            

 

1 Answer Found

 
Answer #1       Answered By: Aakash Gavade          Answered On: Jan 10, 2010       

How many people  are using SharePoint in the company?

This can be simply done by querying the database. Try this

SELECT COUNT(DISTINCT tp_Login) AS Users

FROM UserInfo

Note: Not a good practice to query db.

You can also this information in three ways, by default SharePoint tracks 1
months of usage analysis. _layouts/1033/Usage.aspx. You can also use
FrontPage 2003 to get some of this information. Additional history would
have to be accessed programmatically by parsing the log files. We use
WebTrends as a 3rd  party tool to get some of the metrics.

How many sites  are active?

I guess for portal  areas (sub-webs) you can look at the Publishing Dates, if
there is no expiration set up.

 
Didn't find what you were looking for? Find more on List of active users on Sharepoint Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].