user rights issue

Dear Team,

I have a document library . I give user to view only rights.

Can view pages, list items, and documents. Document types with server-side file handlers can be viewed in the browser but not downloaded

But user still can download .. why ???

Thanks a lot

Reply:

As per my knowledge, if user has access to document he can download it.

SharePoint works this way one thing can be done is to either show/ hide download option based on user permission.

A code tweak.

You can also look for: https://support.office.com/en-us/article/Create-an-information-management-policy-for-a-site-collection-a5808074-ddcd-4ed2-a9cc-228ba6318343?CorrelationId=b7e3f9ee-c107-4e08-85f9-8dbe7a955251&ui=en-US&rs=en-US&ad=US

http://www.sharepointdiary.com/2010/02/sharepoint-permissions-read-vs-view-only-difference.html

Regards,
Rupesh Singh
-------------------------------------------------------------
Please don't forget to mark it as answered, if your problem resolved or helpful.

------------------------------------

Please drop the humberger menu

This menu is the worst idea ever conceived by the human mind when it comes to mobile, and should be removed, together with all the stuff aligned left. They are a pain in the ass for anyone using a smartphone with screen > 4.5

The UI your had in windows phone 8.1/8/7.8/whatever was so much better with all the options and menus easily accessible at the bottom of the device, where you have the navigation buttons.

Right now, you are forcing 2Hand usage of the phone just because...well...I can't think of a proper reason.

If you want to go through with this, at least allow us to move that menu around in ease of access settings or something. And no, the thing you stole from the IPhone with bringing down the window to the middle does not count as ease of access. It is just a horrible band aid.

Also, all the left aligned elements in settings/app drawers and other important places make it really difficult to use the phone.

PS: lumia 830 has horrible wireless connectivity (wifi, bluetooth and mobile) on the preview.

Edited by mcosmin Friday, August 7, 2015 7:17 AM

SP# TOUCH KEYBOARD ALL CAPS

ANYONE BEEN STUCK IN ALL CAPS SINCE THE UPGRADE?

PowerShell File Checksum Integrity Verifier (PsFCIV) is Buggy don't use it

i have entered my comments in the discussion section

https://gallery.technet.microsoft.com/PowerShell-File-Checksum-e57dcd67/view/Discussions

this script posted by Vadims Podans is buggy and should not be used

sanjay

Changed type Bill_Stewart Monday, August 10, 2015 2:10 PM

one drive questions

Hey everyone,

i have a few issues i need some insight on, i just tried to figure out how to use my one drive to access groove music. when i was trying to add my music to one drive its not seeing my music files on my laptop. i was wondering if someone knows if its the one drive giving me issues or if anyone knows how to get the one drive to access my music files. i have tried to drag and drop method but it would move them over. i also tried using the upload option and clicked on my music file and nothing happened there was an error message. and it just said your files failed to upload and it was on the music folder itself. i was wondering if anyone has come across this issue also and if they know how to fix the situation. thank you

sean.

Feedback request: Protecting data in SQL

We (the SQL Security product team) would like to better understand the needs and frustrations of customers who are concerned about protecting their data, both in the cloud and on-premises. If you fit this profile and would be willing to talk with our team, please complete this brief survey:

http://www.instant.ly/s/xRGoh

Thank you for your feedback.

Tommy Mullaney
Program Manager | Microsoft SQL Security

Word 2007 Formula Syntax error - comma returns error

Hi,

I have created an invoice which works perfectly on my Windows 8.1 PC but the same invoice won't work in my Windows 10 PC.

The problem I have is that I receive a syntax error with the formula on the Windows 10 pc.

The formula is =PRODUCT(A2,C2) which multiplies the 2nd line of column 1 with the 2nd line of column 3.

The only way it will work is if I change the comma to an apostrophe i.e.: =PRODUCT(A2;C2) this then works perfectly but it means that I can't edit any invoices on the other machine if I change the template.

What I would like to know is how can the syntax be different from one machine to another?

Have I missed some setting?

Any help would be greatly appreciated.

(both machines have been fully updated with office and windows updates)

Kind Regards Wayne Lal-Singh

Edited by arcadian212 Wednesday, August 5, 2015 10:36 PM

Reply:

The error is due to your regional settings. You can overcome this by not using PRODUCT; instead you can use nothing more complicated than a field coded as:
{=A2*C2}
Such a construction will give the correct result regardless of the PC's regional settings.

Cheers
Paul Edstein
[MS MVP - Word]

------------------------------------
Reply:

Thank you so much. It works!!

------------------------------------

UM Routing Fail when Exchange Server in Maintenance mode

Good morning,

I have a 3 server Exchange DAG (each with the UM role/service) and whenever I place one of the servers in maintenance mode, I get the following alert(s) from Lync/UM:

LS Exchange Unified Messaging Routing(44022 - LS Exchange Unified Messaging Routing): An attempt to route to an Exchange UM server failed. The attempt failed with response code 504: X.X.X.X.
Request Target: [YYY@X.X.X],
Call Id: [ba410a14f4dbd4e007fb08e6b7fcee26].
Failure occurrences: 2, since 6/23/2015 7:54:43 AM.Cause: An attempt to route to an Exchange UM server failed because the UM server was unable to process the request or did not respond within the allotted time.
Resolution:Check this server is correctly configured to point to the appropriate Exchange UM server. Also check whether the Exchange UM server is up and whether it in turn is also properly configured.

When this happens, voicemails destined for that user cannot be left.
Is there a way I can ensure the UM integration knows that an Exchange is offline, to prevent these routing issues? I would have expected the UM integration to 'know' when the Exchange topology changes.

Thanks in advance,

Greg

Reply:

Hello,

I have no problem when I start maintenance mode on my servers.

I presume you run the StartDagServerMaintenance.ps1 script in $exscripts?

Also, are the UM services set the same on all your servers?

Karl

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
My Blog: Unlock PowerShell
My Book: Windows PowerShell 2.0 Bible
My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})

------------------------------------
Reply:

Hello,

Is there any update on this?

Have you also verified that all the servers have the certificate properly bound to the UM service?

1..3|%{Get-ExchangeCertificate -Server server$_ |where services -like *um*}

Verify the thumbprint is equal on all three.

Karl

Edited by Just Karl Thursday, August 6, 2015 10:35 PM

------------------------------------

Virtual Desktop Services

When people consider Virtual desktop services does microsoft provide everything one would need to make that happen?

Why use things like VMW or Dell Wyse, or Citrix ? I am looking for advice and true feedback. I am trying sift through all the junk

Thank you

Reply:

Thank you very much this is very helpful. I have one box pretty strong, but i need to get 300+ users to use applications safely. They do a ton of BYOD and i have no way of protecting what doesn't belong to the company. The end users bring a kinds of stuff to work. So i was thinking a VDI could really help them out. I am running 2012 R2

Thank you Slava

------------------------------------
Reply:

Thank you

------------------------------------

Windows 10 guidance for WSUS 3.2

When can we expect some guidance and a patch for 3.2 to fully support our Win10 clients? The silence from the SUS team is deafening.

-Mike Tanis

Changed type Steven_Lee0510 Tuesday, September 8, 2015 6:51 AM Discussion

Reply:

i haven't even see the ADMX template updates for GPOs yet...things are pretty chaotic right now it seems

------------------------------------
Reply:

i haven't even see the ADMX template updates for GPOs yet...

I have not a Win10 available at the moment, but earlier Windows versions always hade the templates in the \Windows\Inf folder.

Rolf Lidvall, Swedish Radio (Ltd)

------------------------------------
Reply:

Microsoft made the Windows 10 Administrative Templates available on 8/4, available here: https://www.microsoft.com/en-us/download/details.aspx?id=48257

I haven't yet figured out how to get WSUS to see Windows 10 clients to stop reporting as Vista, even with the new templates.

------------------------------------
Reply:

ah very nice, thanks.

that will be an update to WSUS itself so we have to keep an eye out for it

I recall windows 8.1 had the same problem, used to report as 6.3xxxx

------------------------------------

One Drive issues

Hey everyone,

sean.

Moved by Just Karl Thursday, August 6, 2015 5:08 PM Looking for the proper forum.
Changed type Dave PatrickMVP Thursday, August 6, 2015 6:34 PM
Changed type MicroFinn14 Friday, August 7, 2015 12:49 AM one drive questions
Changed type Dave PatrickMVP Thursday, August 13, 2015 3:13 PM
Changed type MicroFinn14 Tuesday, September 8, 2015 2:37 AM its was placed in the wrong spot

Reply:

Hello,

Please ask in the OneDrive forum on Microsoft Community.

As the Microsoft Community is on a different platform, we cannot move the question for you.

Once there, click on Participate near the top of the screen, and select 'Ask a Question' or 'Start a Discussion'

Karl

------------------------------------
Reply:

Hello,

The TechNet Wiki Discussion Forum is a place for the TechNet Wiki Community to engage, question, organize, debate, help, influence and foster the TechNet Wiki content, platform and Community.

Please note that this forum exists to discuss TechNet Wiki as a technology/application.

As it's off-topic here, I am moving the question to the Where is the forum for... forum.

Karl

------------------------------------
Reply:

Hello,

Please ask in the OneDrive forum on Microsoft Community.

As the Microsoft Community is on a different platform, we cannot move the question for you.

Once there, click on Participate near the top of the screen, and select 'Ask a Question' or 'Start a Discussion'

Karl

------------------------------------

Windows 10 PPKG files in MDT?

I was reading http://blogs.technet.com/b/surface/archive/2015/07/31/install-windows-10-on-surface-devices-today.aspx since I have 60+ Surface Pro 3 to deploy. In the blog it mentions using a provision package to install drivers and other settings. Is there a way to do this in MDT? It doesn't import into drivers or OS packages as far as I can tell. If someone has some details on this they can point me to so I can read up I would appreciate. Thanks.

Brian Hoyt

Reply:

I'm planning on making a provisioning package for the Surface (they are bloat-free) as well but I'm going to wait until the next version of MDT is released and I upgrade to the new ADK.

I'll be following their "scenario #2" and using MDT. The hold up is waiting for MDT 2013 Update 1

As I understand it, to use a provisioning package, the computer must already be on Windows 10.

If this post is helpful please vote it as Helpful or click Mark for answer.

Edited by Dan_Vega Wednesday, August 5, 2015 7:50 PM

------------------------------------
Reply:

I am running MDT 2013U1 preview and building images and testing deployment right now. The only issue I have run into is sysprep bug that has existed since Windows 8 and still persists.

Brian Hoyt

------------------------------------
Reply:

Have you looked at this: http://deploymentresearch.com/Research/Post/496/Building-a-Windows-10-Reference-Image-using-MDT-2013-Update-1

I didn't want to bother with the preview and bugs that are being fixed, so I'm going to wait until the final version is out.

If this post is helpful please vote it as Helpful or click Mark for answer.

------------------------------------
Reply:

I don't see anything on how to implement these yet, but it looks like these will be really handy in creating more robust reset and recovery environments, especially when paired with the windows update handling in recovery images now with Win10.

------------------------------------

Windows 10

I do not like Windows 10 after the download. How can I remove it from my computer COMPLETELY!

Reply:

Settings
Update and Security
Recovery

There should be the option to go back to your previous OS.

------------------------------------

FIM pre-requisites for SharePoint 2013 - unable to set compatiblility level as it is a readonly property

I am having a problem setting the compatibility level for SharePoint, prior to installing FIM.
The property is read-only. Is there are registry entry that will complete this?

Here is the environment:

Freshly installed VM with Windows 2012 Std. Server is named: FIMS.
It is domain joined with .Net 3.5 installed.
It also have SQL 2012 Std installed including full-text search.

It has SharePoint 2013 installed...
Configure SQL Server 2012 for SharePoint 2013
http://sharepointpromag.com/sql-server-2012/configure-sql-server-2012-sharepoint-2013

I am stuck at step 1 in the following article to prepare SharePoint for the FIM install.

Installing FIM 2010 R2 on SharePoint Foundation 2013
https://technet.microsoft.com/en-us/library/jj863242(v=ws.10).aspx
Violating any of the above conditions will be caught by the setup prerequisite checks and will block the installation of the portal.

The SharePoint 2013 site collection runs in 2010      experience mode.

     To verify, in the SharePoint 2013 Management command-line shell, enter the following commands and verify that the return value is 14:
- $spSite = SpSite("http://www.contoso.com");
- $spSite.CompatibilityLevel

When I run the command it reports the value is read-only. Advice on how to set this via registry or other mean, is much appreciated.

PS C:\> $spSite = SpSite("http://fims")
PS C:\> $spSite.CompatibilityLevel
15
PS C:\> $spSite.CompatibilityLevel = 14
'CompatibilityLevel' is a ReadOnly property.
At line:1 char:1
+ $spSite.CompatibilityLevel = 14
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : PropertyAssignmentException

Thank you

Reply:

It would appear that using the SharePoint Wizard to create my first farm setup, is responsible for the read only property. Other web sources indicate that it needs to be deleted and to use powershell to re-create it.

So we will abandon FIM entirely and use a third party tool.

Microsoft has excellent documentation, but not for this product.

Might I suggest that someone at MS actually documents an install of FIM on a 2012 Std server, including its dependencies.

------------------------------------

PowerShell V.3 or later version not able to install on LATITUDE E6410 (x64 Win 7 Pro.)

I am facing an issue to install PowerShell v.3 or later version on Dell LATITUDE E6410 having Windows 7 Professional x64 bit system and Service pack 1 already install in it. Whenever I tried to install update  "Windows6.1-KB2506143-x64" at the end of installation it shows error "The following updates were not installed: Update for windows (KB2506143)".Also PowerShell v.4 not installed on system.

Anyone face same issue on above mention system configuration. One of response i received earlier in which he mentioned "Installed Microsoft Readiness Tool then reinstall .net version and again try to install PowerShell v.3" it will resolve the issue but unfortunately it not works.

Any one have an idea what are possible cause for this issue and steps to resolve this ?

Edited by Gomesh S Thursday, August 6, 2015 12:20 PM

Reply:

Have you installed Microsoft .NET Framework 4 or 4.5 to your computer?

https://technet.microsoft.com/fi-FI/library/hh847837.aspx#BKMK_InstallingOnWindows7andWindowsServer2008R2

------------------------------------
Reply:

Yes i have already install .Net Framework 4.5.

------------------------------------

Powershell script for checking sql database MDF and LDF size as well as free space and output will be save as HTML

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")

$filename='DB-Log-File-Info'
$DirectoryToSaveTo = 'C:\PS_test\' #split-path -parent $MyInvocation.MyCommand.Path)+'\'
$date = get-date -format "dd_MMM_yyy_hh_mm_tt"
$date2 = get-date -format "dd-MMM-yyy hh:mm tt"

$ServerList = $DirectoryToSaveTo+'servers_db.txt'
$OutputFile = $DirectoryToSaveTo+$filename+'.html'


$HTML = '<style type="text/css">
#Header{font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;width:100%;border-collapse:collapse;}
#Header td, #Header th {font-size:14px;border:1px solid #98bf21;padding:3px 7px 2px 7px;}
#Header th {font-size:14px;text-align:left;padding-padding-bottom:4px;background-color:#A7C942;color:#fff;}
#Header tr.alt td {color:#000;background-color:#EAF2D3;}
</Style>'

$HTML += "<HTML><BODY>
<b> SQL Databases' Log file Information on : $date2</b> <br>
<Table border=1 cellpadding=0 cellspacing=0 width=100% id=Header>
<TR>
<th>Server Name</th>

<th>Database Name</th>
<th>Physical File Name</th>

<th>Total Size Mb</th>
<th>Used Space Mb</th>
<th>Free Space Mb</th>

<th>Directory</th>

</TR>"

$i = 2

foreach ($ServerIP in Get-Content $ServerList) {
$svr = new-object ('Microsoft.SqlServer.Management.Smo.Server') $ServerIP
$dbfl = @()

foreach ($db in $svr.Databases) {
$dbname = $db.Name

foreach ($fl in $db.LogFiles) {
$dirnm = $fl.FileName | Split-Path -Parent
$filnm = $fl.FileName | Split-Path -Leaf

$dfl = $fl | select @{Name="DBName"; Expression={$dbname}}, @{Name="FileName"; Expression={$filnm} } , @{Name="Total_Size_Mb"; Expression={[math]::round( $_.Size / 1KB, 2) } } , @{Name="Used_Space_Mb"; Expression={[math]::round( $_.UsedSpace / 1KB, 2) } } , @{Name="Free_Space_Mb"; Expression={ [math]::round( ($_.Size - $_.UsedSpace) / 1KB, 2) } } , @{Name="Free_Percnt"; Expression={ [math]::round( (1 - ($_.UsedSpace/$_.Size) )*100, 2) } } , @{Name="Growth_Mb"; Expression={[math]::round( $_.Growth / 1KB, 2) } } , GrowthType , Name , @{Name="Directory"; Expression={$dirnm} }

$dbfl += $dfl

}
}

$dbfl | FOREACH-OBJECT {
$HTML += "<TR >
<TD>"+$ServerIP +"</TD> <TD>"+$_.DBName+"</TD> <TD>"+$_.FileName+"</TD> <TD>"+$_.Total_Size_Mb+"</TD> <TD>"+$_.Used_Space_Mb+"</TD> <TD>"+$_.Free_Space_Mb+"</TD> <TD>"+$_.Directory+"</TD> </TR>"

}

$ip=0

}

$date='_'+$date
$HTML += "</Table></BODY></HTML>"
$HTML | Out-File $OutputFile
write-host $OutputFile

Changed type Vijay415 Thursday, August 6, 2015 12:54 PM

Powershell Script for checking sql services status and account name

$filename='SQL-Service-Info'

#$DirectoryToSaveTo='D:\PowerShell\Fino_Daily_Check_List\'
$DirectoryToSaveTo = 'C:\PS_test\' #split-path -parent $MyInvocation.MyCommand.Path)+'\'
$date = get-date -format "dd_MMM_yyy_hh_mm_tt"
$date2 = get-date -format "dd-MMM-yyy hh:mm tt"

$ServerList = $DirectoryToSaveTo+'servers.txt'
$OutputFile = $DirectoryToSaveTo+$filename+$date+'.html'

$HTML = '<style type="text/css">
#Header{font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;width:100%;border-collapse:collapse;}
#Header td, #Header th {font-size:14px;border:1px solid #98bf21;padding:3px 7px 2px 7px;}
#Header th {font-size:14px;text-align:left;padding-padding-bottom:4px;background-color:#A7C942;color:#fff;}
#Header tr.alt td {color:#000;background-color:#EAF2D3;}
</Style>'

$HTML += "<HTML><BODY>
<b> SQL Services Information on : $date2</b> <br>
<Table border=1 cellpadding=0 cellspacing=0 width=100% id=Header><TR><th>Server Name</th><th>Service Name</th><th>Start Mode</th><th>By Account</th><th>Current State</th><th>Name</th></TR>"

if (!(Test-Path -path "$DirectoryToSaveTo")) #create it if not existing
{
New-Item "$DirectoryToSaveTo" -type directory | out-null
}

foreach ($ServerIP in Get-Content $ServerList) {

$table=Get-WmiObject win32_service -computername $ServerIP | Where-Object {$_.DisplayName -like 'SQL Server (*'} | select DisplayName,Name,StartMode,StartName, State
$table | FOREACH-OBJECT {
$HTML += "<TR ><TD>"+$ServerIP +"</TD><TD>"+$_.DisplayName +"</TD><TD>"+$_.StartMode +"</TD><TD>"+$_.StartName +"</TD><TD>"+$_.State+"</TD><TD>"+$_.Name+"</TD> </TR>"

}
$ip=0

}

$date='_'+$date
$HTML += "</Table></BODY></HTML>"
$HTML | Out-File $OutputFile
write-host $OutputFile

Changed type Vijay415 Thursday, August 6, 2015 12:56 PM

Windows 10 Mail High CPU and I/O

Hi,

I have configured my Gmail and Hotmail account. There are a few issue

1) When the Mail sync, CPU usage goes high (60-70%) as well as Disk I/O (>80%) and this goes on for a few minutes. Also while the sync is going on no mail will be received.

2) Notification intermittently works.

May I know if anyone has experienced this and has found a fix for it? Thanks.

Not seeing Windows 10 Updates

We have Windows 10 selected as a product on our CAS/parent SUP but no updates are coming in for Windows 10. Syncs are completing without any issues I can see. I know at least a few updates for Windows 10 have been released—is this a common issue or localized to just us?

Reply:

Not all updates are released to WSUS and/or they just haven't been put into the WSUS catalog yet. All updates released to this point should get automatically slipstreamed into the upgrade to Win10.

Not sure about new installs exactly though. I think the assumption is that since Windows 10 is not free for enterprises, no systems managed by WSUS should have Win10 yet. That will of course change rapidly though.

Jason | http://blog.configmgrftw.com | @jasonsandys

------------------------------------
Reply:

I might be wrong but I expect the edition released to VLSC to be the same 10240 build as MSDN, etc. and that consumers now have, so the updates will be needed I am guessing. My MSDN copy did have some updates available already so that is why I am wondering if not seeing them is an environmental issue here or if no one can get them yet.

------------------------------------
Reply:

I also wonder about this, since MS has released patches already to RTM, but I too do not see anything in SUP for W10. I enabled W10 products and rescynced, but nothing. Keep us posted :)

------------------------------------
Reply:

Windows 10 updates are already available in ConfigMgr (SUP).

Torsten Meringer | http://www.mssccmfaq.de

------------------------------------
Reply:

I saw the first ones were released on the 4th. Glad it was not just me.

I also noticed Windows 10 LTSB was added as an available product for updates (though I may have missed it previously).

Edited by BryanCP Thursday, August 6, 2015 11:43 AM

------------------------------------

Powershell script for checking database data files as well as log file

#Create a new Excel object using COM
$Excel = New-Object -ComObject Excel.Application
$Excel.visible = $True
$Excel = $Excel.Workbooks.Add()
$Sheet = $Excel.Worksheets.Item(1)
$intRow = 1
ForEach ($instance in Get-Content "C:\Users\vijayy1\Documents\sqlservers.txt")
{
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null
$s = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $instance
$dbs=$s.Databases

$intRow++
#Create column headers
$Sheet.Cells.Item($intRow,1) = "Server: $s"
$Sheet.Cells.Item($intRow,1).Font.Size = 12
$Sheet.Cells.Item($intRow,1).Font.Bold = $True

$intRow++
$Sheet.Cells.Item($intRow,2) = "Database"
$Sheet.Cells.Item($intRow,2).Font.Bold = $True
$Sheet.Cells.Item($intRow,3) = "Data Name"
$Sheet.Cells.Item($intRow,3).Font.Bold = $True
$Sheet.Cells.Item($intRow,4) = "Data File"
$Sheet.Cells.Item($intRow,4).Font.Bold = $True
$sheet.Cells.Item($intRow,5) = "Data Size (MB)"
$Sheet.Cells.Item($intRow,5).Font.Bold = $True
$Sheet.Cells.Item($intRow,6) = "Data Used Space (MB)"
$Sheet.Cells.Item($intRow,6).Font.Bold = $True
$Sheet.Cells.Item($intRow,7) = "Log Name"
$Sheet.Cells.Item($intRow,7).Font.Bold = $True
$Sheet.Cells.Item($intRow,8) = "Log Size (MB)"
$Sheet.Cells.Item($intRow,8).Font.Bold = $True
$Sheet.Cells.Item($intRow,9) = "Log Used Space (MB)"
$Sheet.Cells.Item($intRow,9).Font.Bold = $True
$Sheet.Cells.Item($intRow,10) = "Log File"
$Sheet.Cells.Item($intRow,10).Font.Bold = $True

foreach ($db in $dbs)
{

$dbname = $db.Name
$fileGroups = $db.FileGroups

ForEach ($fg in $fileGroups)
{
# write-host $fg.files | select name
If ($fg)
{

$intRow++

$mdfInfo = $fg.Files | Select Name, FileName, size, UsedSpace
$Sheet.Cells.Item($intRow,2) = $dbname
$Sheet.Cells.Item($intRow,3) = $mdfInfo.Name
$Sheet.Cells.Item($intRow,4) = $mdfInfo.FileName
$Sheet.Cells.Item($intRow,5) = ($mdfInfo.size / 1000)
$Sheet.Cells.Item($intRow,6) = ($mdfInfo.UsedSpace / 1000)

$logInfo = $db.LogFiles | Select Name, FileName, Size, UsedSpace
$Sheet.Cells.Item($intRow,7) = $logInfo.Name
$Sheet.Cells.Item($intRow,8) = ($logInfo.Size / 1000)
$Sheet.Cells.Item($intRow,9) = ($logInfo.UsedSpace / 1000)
$Sheet.Cells.Item($intRow,10) = $logInfo.FileName
}
}
}
$intRow++
}
$Sheet.UsedRange.EntireColumn.AutoFit()

Changed type Vijay415 Thursday, August 6, 2015 12:58 PM

Reply:

And the question here is ... ?

Olaf Helper

[ Blog] [ Xing] [ MVP]

------------------------------------

Ms Support forum

Monday, January 31, 2022