Learn how to use excel generate Batch file

Some time we need to create some batch file with a lot command line from some list , example you have MOSS list in excel then you want add the parameter to stsadm then create batch file.

here is the some command i learn and able to help on the purpose :

=VLOOKUP ( what you want to look , look from where, which column you want the return, false value is exact value)

=REPLACE( start from, start from which location ,how many world u want replace, copy from where )

=CONCATENATE( "string", c1 (Colum parameter)  )
>>>>> results is string [c1 value]

MOSS Diagnostic Logging

 

hey!!! my sharepoint site have error!!! as you get the escalation from user , what log you will check first ?  for me i will check on the following sequence:

 

Event logs : this is the first log to check…because want to know server is working fine or not. (simple way to overview for application and server)

 

IIS LOG: C:\WINDOWS\system32\LogFiles [different web apps have ID, so you can refer to IIS see which folder you should refer to the correct folder ]

Over here you can get more detail on the user information and activity going on at IIS.

 

 

ULS (Unified Logging Service )LOG : [%CommonProgramFiles%\Microsoft Shared\web server extensions\12\LOGS]

This log mainly is for sharepoint log only , you need to enable the log at CA page.

About Subsite backups

From the command line:
Backup Farm/Content Databases: STSADM -o backup -directory
Backup Site Collections: STSADM -o backup -filename
Backup Web/subsite: STSADM -o export

From the UI:
Backup Farm/Content Databases: Central Admin > Operations > Perform a Backup
Backup Site Collections:  emm…not yet discover any free one..u can develop one? not sure DPM able to do that or not…emm…maybe can :D
Backup Web/subsite: SharePoint Designer

CHANGING A SITE COLLECTION URL

Can i rename the URL with STSADM ? oh yeah… stsadm -o renameweb maybe can help ….after check on that this, only can rename the subsites not the root (sites collection URL)

ok so as a conclusion , the only way is Backup , Delete , Restore is the one!!

The command line for doing this would look like:

1. stsadm –o backup –url http://team/sites/site1 -overwrite -filename backupsite1.dat
2. stsadm –o deletesite –url http://team/sites/site1
3. stsadm –o restore –url http://team/sites/site2 -filename backupsite1.dat

MOSSRAP

What is MOSSRAP, that is Risk and Health Assessment Program for Microsoft Office SharePoint Server®.

I am sharing this because just want to keep track the process, so this this is the way i need to learn to become SharePoint consultants.

Program Phase:

1. Environmental Assessment phase ( collect data from machine and staff )
2. Analysis and Reporting phase (compared with Microsoft best practice)
3. Remediation phase. (Recommendations)

Executive summary > summary of environment and action needed

Listed our the issues at high risks and no risks > high risk one need to resolve it immediate

Risk Assessment Scorecards > rate in 3 indicates ( Low , Medium , High)


MOSS RAP Consolidated Scorecard

MOSS Configuration
Customizations ,Farm Topology ,Search ,Security

Operational Excellence
Change Management ,Database ,Disaster Recovery ,Monitoring ,Search ,Service Level Agreement High

Server Configuration
Antivirus ,Database ,Event Logs ,Farm Topology ,IIS Information ,Load Balancing ,Network ,OS Information ,Security

Server Health
Antivirus ,Customizations ,Event Logs ,IIS Information ,Performance ,Security , Security Updates

High Risk Scorecard > List down the high risk area detail
Medium Risk Scorecard > List down the Medium risk area detail
Medium Risk Scorecard > List down the Low risk area detail

Detail for all issues and recommendation :

Issue: <area have issues>
Importance: <why is important>
Recommended Resolution: <Solution or Work around>
Recommended Reading: <Microsoft URL>
Description: <where is the problem>
Detail: <specify the area have problem>