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)

Wednesday, November 10, 2010

Batch file to keep track enumsites with date :D

SET D1=%date:~-4,10%
SET D2=%date:~4,-8%
SET D3=%date:~-7,-5%

set tarik=%D1%%D2%%D3%

echo %tarik%

"C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm" -o enumsites -url http://abc.com > %tarik%.csv

This report will run at scheduled tasks and the purpose is keep track on the sites in which Database , when user need to restore the sites then we only know which DB need to restore back for the sites.

Monday, November 8, 2010

Site Collection Administrator VS Site Owner

hi hi..one of the question ask by interviewer :D . as i understand is about the recycle bin and quota reach limit contact!!  After that i found the answer here :

 

http://blogs.sharepointhosting.com/Lists/Posts/Post.aspx?ID=61

 

About twice a week someone calls or writes into support trying to figure out why their Site Owners cannot reset passwords, manage the recycle bin, or "see everything" in site settings. The answer is pretty easy – you have to be a Site Collection Administrator to be able to perform those actions. The next question we get from Site Owners is "how do I become a Site Collection Administrator?" The answer is easy enough, find out who your current Site Collection Administrator is and ask that individual to promote you to that role. Here's a short tutorial on how to create new Site Collection Administrator.

Take a look at the graphic below (click for full version). It displays the different views if you will see if you log into the Site Settings portion of your WSS 3.0 site as a member of the site owner's group and then as a Site Collection Administrator. Hint – the Site Collection Administrator's view is the top image. You can easily replicate this for yourself if you want to test it out – just create a test user that is a member of the Site Owners (or similar) SharePoint security group and go to the site settings page.

 

Extra this are at site setting :D [all the time our permission is Farm admin , then will never notice about this!! ha ha] Now you know? :D

image

Tuesday, November 2, 2010

How to confirm your update item is going to do incremental crawl or not ?

 

Search problem for the sub sites… unable to get any error from iis, uls log.

 

so we need go to search database to see can get any information.

 

in this case is we want to see the specify sites after i add the item in , this item going to involved in incremental crawl or not.

 

normally we can see the item at MSSChangeLogCookies table before the incremental crawl start.

 

  1. Run this query: select * from dbo.MSSChangeLogCookies order by UpdateTime desc > you will see all the item change going to crawl

This table keeps track of the last change that the crawler processed for each content database.  You'll want to look at the ChangeLogCookie_new column and you'll see several rows but the output of each will look something like this:

 

1;0;1b82082a-66eb-47bb-a053-26dde844f5ac;634242420353000000;7403

 

The GUID 1b82082a-66eb-47bb-a053-26dde844f5ac is the content database id

 

i already have the Database ID on the sites (go to your content DB , check the database information table will know) , so i will search the results and see my database id is available on the MSSChangeLogCookies.

 

if you want see how many crawl from the content DB you check, you can use below query on the targert content db:

select * from eventcache with (NOLOCK) where ID > '’7403'

 

so the total row is the item goign to crawl

 

yeah  !! found the item…so go to run the incremental crawl now…but after run also not working!!! ha ha ha…continue checking….DAY 5

 

here you go for more detail on the .MSSChangeLogCookies :

http://blogs.msdn.com/b/russmax/archive/2008/11/17/how-to-determine-the-number-of-changes-an-incremental-crawl-will-process-prior-to-initiating-the-crawl.aspx

http://www.cnblogs.com/awpatp/archive/2010/11/02/1866938.html > Chinese version

Monday, November 1, 2010

Crawling history from SSP search DB ( SQL Query)

Copy from MS:

 

select * from MSSCrawlhistory

select h.crawlid,
c.catalogid,
c.contentsourceid,
c.startaddressid,
typeofcrawl=
case h.crawltype
when 1 then 'full crawl'
when 2 then 'incremental crawl'
end,
h.status as status_id,
status=
case h.status
when 4 then 'start'
when 9 then 'pause'
when 10 then 'resume'
when 13 then 'stop'
when 11 then 'done'
else 'other'
end,
h.requesttime, h.starttime, h.endtime, datediff(n, h.starttime, h.endtime) as 'duration'
from msscrawlhistory h left join msscrawlcontent c
on h.crawlid=c.crawlid where h.projectid=1 order by h.requesttime desc