which country user step here?

Tag Cloud

MOSS (47) SharePoint 2007 (37) SharePoint 2013 (31) SharePoint 2010 (23) MOSS admin (17) PowerShell (17) admin (17) developer (16) List (15) WSS (14) sql query (14) MOSS SP2 (13) end user (11) scripting (11) wss V3 (11) permission (10) sql (9) Moss issue (8) search (8) database (7) RBS (6) Service Pack (6) reportadmin (6) workflow (6) CU (5) Excel (5) Patch (5) client object model (5) Client Code (4) Command (4) Cumulative Updates (4) IIS (4) SharePoint 2019 (4) SharePoint designer (4) office 365 (4) stsadm (4) user porfile (4) ASP.NET (3) Content Database (3) Groove (3) Host Named Site Collections (HNSC) (3) SharePoint 2016 (3) Tutorial (3) alert (3) authentication (3) batch file (3) codeplex (3) domain (3) error (3) incomming email (3) issue (3) restore (3) upload (3) Caching (2) DocAve 6 (2) Folder (2) Index (2) Internet (2) My Site Cleanup Job (2) My Sites (2) News (2) People Picker (2) Share Document (2) SharePoint admin (2) View (2) Web Development with ASP.NET (2) add user (2) audit (2) coding (2) column (2) deploy solution (2) download (2) enumsites (2) exam (2) export (2) june CU (2) load balance (2) mySites (2) network (2) orphan site (2) performance (2) profile (2) project server (2) query (2) security (2) server admin (2) theme (2) timer job (2) training (2) web master (2) web.config (2) wsp (2) 70-346 (1) 70-630 (1) AAM (1) Anonymous (1) Approval (1) AvePoint (1) Cerificate (1) Consultants (1) Content Deployment (1) Content Type (1) DOS (1) Document Library (1) Drive Sapce (1) Excel Services (1) Export to Excel (1) Feature (1) GAC (1) Get-SPContentDatabase (1) Get-WmiObject (1) HTML calculated column (1) ISA2006 (1) IT Knowledge (1) ITIL (1) Install (1) Link (1) MCTS (1) Macro (1) Masking (1) Migration (1) NLBS (1) Nintex (1) Office (1) Open with Explorer (1) ROIScan.vbs (1) Reporting Services (1) SPDisposeCheck.exe (1) SQL Instance name (1) SSRS (1) Sandbox (1) SharePoint Online (1) SharePoint farm (1) Shared Services Administration (1) Site Collection Owner (1) Site template (1) Skype for business (1) Steelhead (1) Teams (1) URLSCAN (1) VLOOKUP (1) WSS SP2 (1) XCOPY (1) abnormal incident (1) admi (1) app (1) application pool (1) aspx (1) availabilty (1) backup (1) binding (1) blob (1) branding sharepoint (1) cache (1) calendar (1) change password (1) connection (1) copy file (1) counter (1) crawl (1) custom list (1) domain security group (1) event (1) excel 2013 (1) facebook (1) filter (1) fun (1) group (1) iis log (1) import (1) import list (1) improment (1) interview (1) keberos (1) licensing (1) log in (1) metada (1) migrate (1) mossrap (1) notepad++ (1) onedrive for business (1) operation (1) owa (1) process (1) publishing feature (1) resource (1) send email (1) size (1) sps2003 (1) sql201 (1) sql2012 (1) sub sites (1) system (1) table (1) task list (1) today date (1) trial (1) vbs (1) video (1) web part (1) web server (1) widget (1) windows 2008 (1) windows 2012 R2 (1) windows Azura (1) windows account (1) windows2012 (1) wmi (1)

Sunday, March 28, 2010

Formulas in calculated columns

hi hi.. recently start work on Sharepoint admin area also, so now want to share about the simple formulas in calculated columns. At the custom list you can add in one new column with calculated type, then can use simple formula to pull data from othe column and do some calculation .
Below is the simple formula for IF :
=IF(Column1<=Column2, "OK", "Not OK")
However using the function like that causes a syntax-error.
The correct syntax is
=IF(Column1<=Column2; "OK"; "Not OK")
Date and time, Financial, Information, Logical, Lookup and reference, Math and trigonometry, Statistical,Text and data
http://office.microsoft.com/en-us/sharepointtechnology/CH100650061033.aspx
http://office.microsoft.com/en-us/sharepointtechnology/HA011609471033.aspx

Thursday, March 25, 2010

Overview of usage reports

The following usage reports are available:


  • Site usage report Site administrators, including administrators of the Shared Services Administration site, can view usage reporting for their site by clicking Site usage reports in theSite Administration section of the Site Settings page.

  • Site collection usage report Site collection administrators for most site collections can view usage reporting by clicking Site collection usage reports in the Site Collection Administrationsection of the Site Settings page.

  • Site collection usage summary Site collection administrators for the Shared Services Administration site and individuals with personal sites can view the Site Collection Usage Summary page by clicking Usage summary in the Site Collection Administration section of the Site Settings page.
[Below information from Kevin-lam]
Problem description:
=================
The data in SpUsageWeb.aspx don’t match the data in the UsageDetails.aspx page.

Plan:
==================
The issue is fixed in the April’s Service Pack, which is going to be released. We are now testing the Service Pack and will update you once we finish the test.
If no exception, I will send you the Service Pack early next week. Then you can try and see if the issue can be fixed by the Service Pack.

Additional information:
==================
The _layouts/usagedetails.aspx page is still available in SharePoint 2007, although there is no link to it in the site settings page.
If the Site Usage Report works properly, the data in the usagedetails.aspx should match the data in the SpUsageWeb.aspx.

Tuesday, March 23, 2010

VLOOKUP for you to join table

Just now try to gather all the DB size from DB and SharePoint CA, to join the data from DB and sharepoint at excel i use the VLOOKUP :

From CA Content DB
Database Name Database Status Current Number of Sites Site Level Warning Maximum Number of Sites
Contend_DB1 Started 4 8 10

From SQL Query > use this command at SQL query exec sp_databases
DB name Size MB GB
Contend_DB1 165860032 161972.69 158.1764526

Combine the data in one excel sheer : DB size GB with following VLOOKUP
 =VLOOKUP(A2(this is the data you want to match), [the rage of the SQL query data],4(which role want to return),FALSE)
Database Name DB Size GB Database Status Current Number of Sites Site Level Warning Maximum Number of Sites
Contend_DB1 158.1764526 Started 4 8 10

Wednesday, March 17, 2010

Windows SharePoint Services 3.0 Service Pack 1 Retired at 13/07/2010

woo!!!  are you already upgrade your sharepoint server up to SP 2? if not please act faster!!! Microsoft going to   stop the support for SP1 soon. http://support.microsoft.com/lifecycle/?p1=12200Windows SharePoint Services 3.0 Service Pack 1 Retired at 13/07/2010

I have some blog to share about the SP2 installation step at here, feel free to have a look. or you can just do search over internet than you will see a lot people share on this :) . If you environment not really have a lot customization then you will easy for the upgrade :)