PC-SPIM - MIPS

How to get last string value

2017-02-02T09:48:00.004-08:00

declare @lastString varchar(50);
SELECT @lastString = Field FROM [Table] WHERE Field='2015,1289,613431220'

SELECT SUBSTRING(@lastString , LEN(@lastString) - CHARINDEX(',',REVERSE(@lastString)) + 2 , LEN(@s) )

How to clear Query string value in asp.net

2013-12-06T09:57:00.002-08:00

PropertyInfo isreadonly = typeof(System.Collections.Specialized.NameValueCollection).GetProperty("IsReadOnly", BindingFlags.Instance | BindingFlags.NonPublic);
                // make collection editable
                isreadonly.SetValue(this.Request.QueryString, false, null);
                // remove
                this.Request.QueryString.Remove("id");

http://www.codeproject.com/Questions/310625/How-to-clear-Query-string-value-in-net

Enabling NTLM Authentication (Single Sign-On) in Firefox

2013-06-13T04:18:00.001-07:00

This HowTo will describe how to enable NTLM authentication (Single Sign-On) in Firefox.
How many of you have noticed that when you are using Internet Explorer and you browse to your companies intranet page that it will automatically authenticate you but when you use Firefox you will be prompted with a login box?
I recently, in searching for solutions to allow NTLM authentication with Apache, stumbled across how to set a preference in Firefox that will pass the NTLM authentication information to a web server. The preference is network.automatic-ntlm-auth.trusted-uris.
So how do you do it?
1) Open Firefox and type "about:config" in the address bar. (without the quotes of course)
2) In the 'Filter' field type the following "network.automatic-ntlm-auth.trusted-uris"
3) Double click the name of the preference that we just searched for
4) Enter the URLs of the sites you wish to pass NTLM auth info to in the form of:

http://intranet.company.com,http://email.company.lan

5) Notice that you can use a comma separated list in this field.
6) Updated: I have created VBScript that can be used to insert this information into a users prefs.js file by using group policy or standalone if for some reason you want to use it for that.

http://sivel.net/2007/05/firefox-ntlm-sso/

how to format datetime in gridview for minutes OR Date

2013-05-06T09:55:00.000-07:00

FORMAT MINUTES
<asp:BoundField DataField="HoraAT" HeaderText="Hora" ReadOnly="True" SortExpression="HoraAT" DataFormatString="{0:hh}:{0:mm}" />

FORMAT DATE

<asp:BoundField DataField="CriatedOn" HeaderText="CriatedOn" DataFormatString="{0:yyyy-MM-dd}" SortExpression="CriatedOn" Visible="false"/>

Howe to make random top X rows sql

2013-04-26T07:51:00.000-07:00

SELECT TOP [Number] [Field] FROM [TableName]
ORDER BY NEWID()

How to convert DateTime to Hour / Minute / Second

2013-04-04T01:23:00.001-07:00

SELECT
CONVERT(VARCHAR(8) , GETDATE() , 108) AS HourMinuteSecond,
CONVERT(VARCHAR(5) , GETDATE() , 108) AS HourMinute

How to make UPDATE SELECT

2013-03-28T09:47:00.002-07:00

UPDATE [TableName]
SET [Field]= BB.[Field]
FROM [TableName] BB
INNER JOIN [TableName] AA ON BB.[Field] = AA.Field

Javascript LOGON_USER

2013-03-19T08:13:00.000-07:00

SyntaxEditor Code Snippetvar WinNetwork = new ActiveXObject('WScript.Network');
document.getElementById('"+Logon.Id+"').value = WinNetwork.UserName;

SCCM Programs used by users in the last 7 days

2013-03-08T11:11:00.001-08:00

SELECT DISTINCT DATEDIFF(DAY, rua.lastusedtime0, GETDATE())AS[Days Since Last Used]
,sysvalid.netbios_name0 AS [Computer Name]
,rua.productname0 AS APPLICATION
,rua.filedescription0 AS [File Description]
,rua.explorerfilename0 AS [File Name]
,rua.fileversion0 AS [File Version]
,rua.companyname0 AS publisher
,CASE WHEN ( ISNULL(rua.productcode0, N'') = N'') THEN 'N'ELSE 'Y'END AS [Associated with an Installer]
,rua.lastusedtime0 AS [Time Last Used(GMT)]
,rua.lastusername0 AS [Last Used By]
,rua.TimeStamp
FROM [dbo].v_gs_ccm_recently_used_apps AS rua
LEFT JOIN[dbo].v_r_system_valid AS sysvalid ON rua.resourceid = sysvalid.resourceid
WHERE lastusername0 Like '%@user%' AND rua.ExplorerFileName0 NOT LIKE '%.tmp' AND rua.fileversion0 NOT LIKE ''
AND DATEDIFF(DAY, rua.lastusedtime0, GETDATE())<=7

SCCM DETAILS DISK

2013-03-08T11:08:00.006-08:00

/********** DETAILS DISK *****************/
SELECT GD.InterfaceType0,GD.Name0,(GD.Size0),gd.Partitions0,GD.ResourceID
FROM [dbo].[v_GS_DISK] GD
WHERE GD.ResourceID=@ResourceID

/********** DETAILS DISK *****************/
SELECT Ld.Description0,ld.DeviceID0,Ld.FileSystem0,LD.FreeSpace0,LD.Size0,LD.VolumeName0
FROM [dbo].[v_GS_LOGICAL_DISK] LD
WHERE LD.ResourceID=@ResourceID

SCCM 2012 View installer programs by ResourceID

2013-03-08T04:21:00.001-08:00

SELECT vARP.DisplayName0, vARP.Publisher0, vARP.Version0 ,vARP.InstallDate0,vARP.TimeStamp
FROM[dbo].v_Add_Remove_Programs vARP
JOIN [dbo].v_R_System vRS ON vARP.ResourceID = vRS.ResourceID
WHERE vRS.ResourceID = @ID

SCCM Disk space for all servers IN C:

2013-03-08T03:49:00.003-08:00

SELECT DISTINCT VFCM.Name,VGL.DeviceID0, VGL.Description0, VGL.VolumeName0,
VGL.FreeSpace0 as [Free(MB)],
VGL.FreeSpace0/1024 as [Free(GB)],
VGL.Size0/1024 as [Total(GB)],
VGL.FreeSpace0*100/VGL.Size0 AS X
FROM[dbo].v_FullCollectionMembership VFCM
JOIN [dbo].v_GS_LOGICAL_DISK VGL on VFCM.ResourceID = VGL.ResourceID
JOIN[dbo].v_R_System VRS ON VFCM.ResourceID = VRS.ResourceID
WHERE
VGL.DriveType0 =3
AND VGL.DeviceID0 = 'C:'
ORDER BY VFCM.Name, VGL.DeviceID0

Chassis type values in SCCM

2013-03-08T03:39:00.003-08:00

when 1 then 'Other'

when 2 then 'Unknown'

when 3 then 'Desktop'

when 4 then 'Low Profile Desktop'

when 5 then 'Pizza Box'

when 6 then 'Mini Tower'

when 7 then 'Tower'

when 8 then 'Portable'

when 9 then 'Laptop'

when 10 then 'Notebook'

when 11 then 'Hand Held'

when 12 then 'Docking Station'

when 13 then 'All in One'

when 14 then 'Sub Notebook'

when 15 then 'Space-Saving'

when 16 then 'Lunch Box'

when 17 then 'Main System Chassis'

when 18 then 'Expansion Chassis'

when 19 then 'SubChassis'

when 20 then 'Bus Expansion Chassis'

when 21 then 'Peripheral Chassis'

when 22 then 'Storage Chassis'

when 23 then 'Rack Mount Chassis'

when 24 then 'Sealed-Case PC

Ref:http://blogs.technet.com/b/breben/archive/2009/07/21/chassis-type-values-in-sccm.aspx

trick folder GodFolder

2013-01-25T07:11:00.001-08:00

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
Paste this name folder :) Enjoy

How to make SQL Backup All DataBases

2013-01-25T06:09:00.002-08:00

DECLARE @Baksql VARCHAR(8000)
DECLARE @BackupFolder VARCHAR(100)
DECLARE @BackupFile VARCHAR(100)
DECLARE @BAK_PATH VARCHAR(4000)
DEclare @BackupDate varchar(100)
-- Setting value of backup date and folder of the backup
SET @BackupDate = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR,GETDATE(),120),'-',''),':',''),' ','_') -- 20110517_182551
SET @BackupFolder = 'C:\Backups\'
SET @Baksql = ''
-- Declaring cursor
DECLARE c_bakup CURSOR FAST_FORWARD READ_ONLY FOR
SELECT NAME FROM SYS.DATABASES
WHERE state_desc = 'ONLINE' -- Consider databases which are online
AND database_id > 4 -- Exluding system databases

-- Opening and fetching next values from sursor
OPEN c_bakup
FETCH NEXT FROM c_bakup INTO @BackupFile
WHILE @@FETCH_STATUS = 0
BEGIN
SET @BAK_PATH = @BackupFolder + @BackupFile
-- Creating dynamic script for every databases backup
SET @Baksql = 'BACKUP DATABASE ['+@BackupFile+'] TO DISK = '''+@BAK_PATH+'_FullBackup_'+@BackupDate+'.bak'' WITH INIT;'
-- Executing dynamic query
PRINT (@Baksql)
EXEC(@Baksql)
-- Opening and fetching next values from sursor
FETCH NEXT FROM c_bakup INTO @BackupFile
END
-- Closing and Deallocating cursor
CLOSE c_bakup
DEALLOCATE c_bakup

Field GridView with Link with Parameter

2013-01-24T02:25:00.000-08:00

<asp:HyperLinkField Text="<img src='../Img/view.png' alt='alternate text' border='0'/>"
                    DataNavigateUrlFields="Id" DataNavigateUrlFormatString="PAGE.aspx?Id={0}"
                    HeaderImageUrl="../Img/view.png" >
                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:HyperLinkField>

Object Data Source Select Parameter

2013-01-24T02:22:00.001-08:00

DataGridView COL with Image

2013-01-24T02:19:00.000-08:00

<asp:TemplateField>
<ItemTemplate>
<asp:Image ID="Image1" Height="32px" runat="server" ImageUrl='<%# String.Format("{0}{1}{2}", "PATH", Eval("FIELD"),".jpg") %>' />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:TemplateField>

Convert short

2013-01-24T01:52:00.004-08:00

Convert.ToInt16(field)

How to view Server Variables

2013-01-16T06:11:00.002-08:00

foreach (string x in Request.ServerVariables)
{
Response.Write(x + ": " + Request.ServerVariables[x] + "<br>");
}

NTLM - ASPX C#

2013-01-16T04:29:00.003-08:00

Properties project

Servers

click checkbox -> NTLM authentication

web.config

<authentication mode="Windows">
</authentication>

IIS

Authentication -> windows authentication -> Enable
Authentication -> windows authentication -> Providers -> put NTLM first

How to make Upper first CHAR Word

2012-11-02T05:16:00.003-07:00

UPDATE [TableName]
SET = UPPER(LEFT(LOWER(), 1)) + SUBSTRING(LOWER(), 2, LEN())

SQL multi facts

2012-09-25T02:24:00.002-07:00

declare
@A int = 1 ,@B int = 3 , @C int =20 , @D int =16

INSERTINTO @temp(A,B,C,D)
SELECT *
FROM
(
SELECT 1 As A, 2 AS B, 3 AS C, 4 AS D
UNION SELECT 1 As A, 2 AS B, null AS C, null AS D
UNION SELECT 1 As A, 2 AS B, 4 AS C, 5 AS D
UNION SELECT 1 As A, 3 AS B, 2 AS C, null AS D
UNION SELECT 1 As A, 3 AS B, 2 AS C, 7 AS D
UNION select 1 As A, 3 AS B, null AS C, null AS D
) A

SELECT
TOP 1 * FROM

@temp
WHERE
(A = @A AND B=@B AND C=@C AND D=@D) OR
(A = @A AND B=@B AND C=@C AND D IS NULL) OR
(A = @A AND B=@B AND C IS NULL AND D IS NULL) OR
(A = @A AND B IS NULL AND C IS NULL AND D IS NULL)
orderby D DESC,C DESC,B DESC,A DESC

FeedbackMessage

2012-09-24T07:40:00.002-07:00

.ASPX AFTER

/Imagens/delete.gif" onclick="hidemsm();" style="cursor: pointer;" />

<%= this.message %>

.CSS --------------------------------------------------------------------------------- .errorBox { border:solid 2px Red; padding: 3px 3px 3px 3px; color:Red; text-align:left; } .errorImage { vertical-align:bottom; margin-bottom:-5px; } .InfoBox { border:solid 1px Blue; padding: 3px 3px 3px 3px; font-size:11px; } .InfoImage { vertical-align:bottom; margin-top:-6px; } .msbox { position: fixed; width: 400px; float:left; z-index: 8000; top: -50px; left:40%; } .msboximg { position: absolute; float: right; right: -10px; top: -10px; } .messagebox { background-color: Blue; height: 40px; text-align: center; width: 100%; } .MessageText { vertical-align: middle; margin-top: 5px; font-family: Trebuchet MS; color: White; } .userbox { background-color: #90D0f0; } .contentbox { background-color: #F5F9FF; } --------------------------------------------------------------------------------- .CS public enum MessageType{SUCCESS,WARNING,INFO,FAIL}; public void ShowMessage(string message,MessageType Type = MessageType.INFO,string MoreInfo="") { this.message = message; this.msmtext.Attributes["Title"] = MoreInfo; switch(Type) { case MessageType.FAIL: this.Messagebox.Style["background-color"] = "Red"; break; case MessageType.INFO: this.Messagebox.Style["background-color"] = "Blue"; break; case MessageType.SUCCESS: this.Messagebox.Style["background-color"] = "Green"; break; case MessageType.WARNING: this.Messagebox.Style["background-color"] = "Orange"; break; } }

SQL generate Years <=100

2012-09-24T07:28:00.002-07:00

WITH ListYear AS
     ( SELECT 1913 AS YEAR
             UNION ALL
        SELECT lyear.YEAR + 1 AS YEAR
        FROM ListYear lyear
        WHERE lyear.YEAR + 1 <= YEAR(GetDate())
     )
SELECT YEAR FROM ListYear ORDER BY YEAR DESC;